DbSchema Sqlite Client and Diagram Designer

  • DbSchema is a Sqlite diagram-oriented database client and designer with integrated data and query tools. No database experience required - the tool is visual.
  • DbSchema is managing its own internal copy of the schema, distinct from the database. This makes possible to design a schema and deploy it on multiple databases, generate migration scripts or share the design project file in a team.
  • DbSchema can manage Sqlite databases. No SQL experience required - the tool is visual.
  • DbSchema can be evaluated 15 days for free.

DbSchema Database Designer

Sqlite Interactive Diagrams

Sqlite Diagram Designer Manage Sqlite schema via interactive diagrams. Create new tables, columns and indexes directly in the diagram. The diagrams can be exported as HTML vector images.

  • Schema can be edited directly in the layouts (diagrams).
  • The layouts are saved to project file and reopen next time you access the application
  • HTML5 documentation with interactive vector image can be exported. Sample here.
  • Foreign keys can be drawn using different notations, with lines pointing to tables or to columns.
Video Introduction Read more »

Relational Data Browse

Sqlite Data Explorer Relational Data Browse is a visual data explorer from multiple tables simultaneously. View one table data and then open further tables having foreign keys or virtual foreign keys and view related records.

Data can be edited, filters can be set.

The editor will be saved to file and reopen next time you access the application. In this way you can build different perspectives over the data and reuse them whenever you need.

Video Introduction Read more »

Schema Synchronization

Convert Schema to Sqlite DbSchema use its own project with schema structure and diagrams, which will be saved to project file. This makes possible to design schema independent from the database and deploy it on multiple databases.

The project file is in XML format. The project file can be stored in GIT and shared in a team.

Restarting DbSchema will open the last saved project file. To ensure the project schema is the same as in the database press 'Refresh schema from database' from the menu. Next you can refresh complete schema or take an action for each difference : merge in DbSchema or in the database.

Video Introduction Read more »

Visual Query Builder, Query Editor and Random Data Generator

Sqlite visual query builder and query editor

  • Visually create SQL queries using the query builder. Multiple JOIN clauses can be used, including LEFT OUTER JOIN, EXISTS, etc. or group by clauses. The joins are using the foreign keys or virtual foreign keys.
  • The Query editor with text-autocompletion, script execution and graphical explain plan.
  • Random data generator using reverse regular expressions and predefined patterns.

Video Introduction Read more »

Database Forms and Reports | Database Manager

Sqlite Forms and Reports DbSchema Sqlite forms and reports can be used to build applications or reports and run them as JavaFx or Web applications. Based on the forms designer we started building Sqlite applications for space, permission and activity management.

Read more »

For a better database design you may need good database documentation, diagrams and virtual foreign keys. Administrators and developers may enjoy the Relational Data Browse for the easiness to explore data. Using the Visual Query Builder you will save time and enjoy SQL. Schema synchronization will help you to deploy the schema on multiple databases.

Free Trial

Download DbSchema and try it 15 days for free.

Technical Support

Registered and unregistered users may benefit from technical support.

1 Year Renewals Included

Purchase DbSchema and you will get 1 year free updates to new developed features and fixes.

Money Back Guarantee

Not happy with DbSchema ? 30 days after purchase you can claim your money back.

Start using DbSchema right now !

DbSchema can be evaluated 15 days for free.

DbSchema can run on all operating systems: Windows, Linux, MAC.

DbSchema Database Tool