有好些sqlite数据库编辑工具是收费的,好不容易找了几个免费的.

1.SQLite Database Browser

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to: Create and compact database files Create, define, modify and delete tables Create, define and delete indexes Browse, edit, add and delete records Search records Import and export records as text Import and export tables from/to CSV files Import and export databases from/to SQL dump files Issue SQL queries and inspect the results Examine a log of all SQL commands issued by the application

What it is not This program is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands. It is a tool to be used both by developers and by end users, and it must remain as simple to use as possible in order to achieve its goals.

语言:英文
官方介绍: http://sqlitebrowser.sourceforge.net/  
下载地址: http://sourceforge.net/projects/sqlitebrowser/
本地下载:sqlitebrowser-1.3-win.zip

2.SQLiteSpy

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases.

语言:英文
官方地址: http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index?DokuWiki=gh6co6epiepc51r48hgi00q5m4  

下载地址: http://www.yunqa.de/delphi/lib/exe/fetch.php?cache=cache&media=http%3A%2F%2Fwww.yunqa.de%2Fdelphi%2Fdownloads%2FSQLiteSpy_1.8.10.zip

本地下载: sqlitespy_1.8.10.zip

3.SQLiteAdmin

SQLite Administrator is a powerful tool if you easily want to create, design or administrate SQLite database files. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator.

语言:多语言,有中文
官方网站:http://sqliteadmin.orbmu2k.de/
下载地址:http://download.orbmu2k.de/download.php?id=19  
本地下载:sqliteadmin.zip