Search This Blog

Thursday, March 24, 2011

SQLite GUI; SQLite executing commands

I’ve found a nice GUI for SQLite. It’s from ‘tksqlite’ project located here. You can download a working version here.

From console (sqlite3.exe) you can do the following:

.read FILENAME – execute a file with sql commands;
.databases – list databases
.tables – list tables
.headers ON – display table headers while executing (SELECT * …)
.schema – display database schema

Remember to open sqlite3.exe with a database argument:

sqlite3.exe database.db


  1. Thanks for pointing the way to the tksqlite gui. Simple, elegant, and it works beautifully. Great for newbies like me.


  2. You can check one more free GUI tool for sqlite - Valentina Studio


If you like this post, please leave a comment :)