Tclodbc uses an object-based design. You first create a database connection with the database connect command. This returns a database object ID that is also a new Tcl command. SQL statements can then be passed to the database object ID command.

The database ID statement command creates a compiled SQL query, which can then be efficiently executed many times. The command returns a statement ID and creates a new Tcl command that accepts statement ID commands.

Multiple database IDs and statement IDs can be created and active at the same time.