[v4.2.0] SQLite Expert – Powerful administration tool for your SQLite database

SQLite Expert is currently the most excellent SQLite database visual manager, which allows user to create, edit, copy, extract, and perform other database operations on a SQLite server. It is known as the best auxiliary software to develop SQLite3 database.

SQLite Expert supports all SQLite features designed for graphical interface. This includes a visual query builder, a SQL editor with syntax highlighting function, code autocomplete, powerful table and view designer, import and export function, etc. In addition, it can easily establish complex SQL queries, supports import and export database, supports encrypted database, and so on.

BTW, when the function of the freeware SQLiteSpy and SQLiteStudio can’t meet your needs, do remember to give SQLite Expert a try. You won’t be disappointed.

// Key Features //

  • Manage SQLite3 databases: create database, view/change parameters
  • Repair damaged databases
  • Database DDL compare tool
  • Online backup of databases
  • Check integrity, reindex all tables, transaction support
  • Supports attached databases and SQLite extensions
  • Manage tables: create, delete, rename, reindex
  • Restructure tables: fields, indexes, foreign keys, unique and check constraints, triggers
  • Manage views: create, delete, rename, restructure. Manage view triggers
  • Supports temporary tables and views
  • Supports virtual tables including RTREE, FTS3 and FTS4
  • Includes ICU extension
  • Advanced SQL editor with code completion and syntax highlighting
  • Multiple SQL tabs
  • Advanced data editing capabilities in the grid: image, BLOB and text editors
  • Custom and predefined data types
  • Copy/Paste records between tables via clipboard
  • Copy/Paste tables between databases via clipboard
  • Full Unicode support
  • Customize the look and feel of the application using skins
  • Visual SQL Query Builder
  • Copy tables between databases using drag and drop
  • Supports password protected databases (requires third party SQLite library – not included)
  • Supports SQLite auto extensions
  • Export data to Excel, XML, HTML, CSV, TSV, ADO data sources, SQL script, SQLite database
  • Import data from ADO data source, SQL script, SQLite, CSV, TSV
  • Send the contents of any grid to printer or export it to a PDF file
  • Generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table
  • Lua and Pascal scripting support

// Edition Statement //

AppNee provides the SQLite Expert Professional Edition multilingual portable full registered versions for Windows 32-bit and 64-bit.

// Download URLs //

License Version Download Size
Personal Edition v4.x.x 32-bit | 64-bit n/a
Professional Edition v4.2.0 32-bit | 64-bit 26.1 MB | 27.5 MB


// Related Posts //
Locate32 – Quick and easy local file/folder search
Locate32 is a small, fast local search applet, I think when you see that this is a local search tool, you may very naturally think of Google Desktop, and believe ...
MakeRoom – Find out hard disk space killer quickly and visually
MakeRoom is a hard disk space analysis app with beautiful interface and novel way of scanning. It can quickly scan all the folders in the whole hard disk, and then arrange ...
SumatraPDF – Small and fast multi-format universal eBook reader
Software's size and function are growing with each passing day, yet those small ones are always welcome by users. Foxit Reader and PDF-XChange Viewer have taken over the market of the ...
Vbs To Exe – Convert VBS files to EXE format
Vbs To Exe is an straightforward and intuitive small freeware written (based on Visual Basic scripting language) for developers. It can quickly convert VBS format of script files to EXE ...
[v5.8.1] YTD Video Downloader – Simple and fast streaming video downloader & converter
YTD Video Downloader is a universal professional web video direct downloading tool with simple, intuitive UI & using method. It's original name is YouTube Video Downloader, from which we can see ...
InPixio Photo Clip – Flawless digigal photo unwanted objects remover
The vast majority of us are not professional photographers, as a result, it's really difficult to shoot satisfactory/perfect photos - one of the biggest flaws is it often contains some ...
[PSX] Castlevania: Symphony of the Night ROM + Emulator download
Castlevania: Symphony of the Night (ANA: 悪魔城ドラキュラX 月下の夜想曲, Akumajō Dracula X: Gekka no Yasōkyoku, Devil's Castle Dracula X: Nocturne in the Moonlight) closely follows the storyline of Castlevania: Rondo of Blood, ...
Registry Finder – Efficient and quick Windows Registry searcher & editor
Registry Finder is a handy and fast Windows Registry searching & editing tool. It can quickly find, locate specific content using keywords in the registry. Obviously, it's specially developed for ...
[v4.19.8] MyLanViewer – Powerful and handy LAN/IP scanner & listener
MyLanViewer is a simple yet powerful local area network (LAN) scanning and IP monitoring tool. It has user-friendly UI, is very easy to get started, specially designed for network administrators. On ...
IconsExtract – Extract hidden icon resources from EXE/DLL/OCX/CPL files
IconsExtract is an icon resource extraction applet, it allows to scan all files and folders in your PC, and then extracts the icons and mouse styles stored in EXE, DLL, ...
Locate32 – Quick and easy local file/folder search
MakeRoom – Find out hard disk space killer
SumatraPDF – Small and fast multi-format universal eBook
Vbs To Exe – Convert VBS files to
[v5.8.1] YTD Video Downloader – Simple and fast
InPixio Photo Clip – Flawless digigal photo unwanted
[PSX] Castlevania: Symphony of the Night ROM +
Registry Finder – Efficient and quick Windows Registry
[v4.19.8] MyLanViewer – Powerful and handy LAN/IP scanner
IconsExtract – Extract hidden icon resources from EXE/DLL/OCX/CPL

  • Copy text content from AppNee: You are welcomed to do this, but do remember one thing: leave us a backlink. Otherwise, finally you will destroy our pay and effort, and get yourself blacklisted/banned by the entire SAYS group.
  • Download link: Any download link does not work, email us to fix it for you.
  • Software version: Want to get newer version of some software, email us.
  • Virus scan: Always remember to do this by yourself using VirusTotal or VirSCAN (more trustworthy). Sometimes, we may forget it or get infected with virus.
  • Email reply: As long as we could take time out from daily work & study, we would manage to answer every email worth to reply as soon as possible.
  • Software recommendation: For excellent software you're finding but we did not share (make sure you searched through AppNee first), please let us know (via the Feedback). Then we will do our best to find all possible resources for you. But, there is no guarantee.
  • Warnning: Before asking any questions, you'd better make sure you have read the post through, and do not use a fake email. Besides, never put too much hope on AppNee, or you will be very disappointed.