Letos
Letos is a free, open-source SQLite database management application that allows users to create, browse, edit, and maintain SQLite databases through a graphical interface. Formerly known as SQLiteStudio, the software provides tools for managing database tables, views, indexes, triggers, and relationships without requiring extensive command-line operations. Its advanced SQL editor includes syntax highlighting, code completion, query formatting, error detection, and execution history to simplify database development. Letos also provides a visual entity relationship diagram (ERD) editor for designing database schemas and managing relationships between tables. Additional capabilities include importing and exporting data, managing encrypted SQLite databases, generating test data, and creating custom SQL functions through scripting. The application runs on Windows, macOS, and Linux, supports portable deployment, and is distributed under the GPL license without subscription fees or telemetry.
Learn more about Letos
DbSchema
5.0 out of 5 stars
(1 Rating)
DbSchema is for visual designing the schema in a team, deploy and document the schema. Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema an every-day tool for everybody who interacts with databases. DbSchema supports all relational and No-SQL databases, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google and more. DbSchema is reverse-engineering the database schema from the database and visualize it as diagrams. You will interact with the database using diagrams and visual tools. DbSchema model is using its copy of schema structure, independent from the database. This allows the schema deployment on multiple databases, save the design model to file, store it in GIT and design the schema in a team, design the schema without database connectivity, compare different versions of the schema and generate SQL migration scripts.
Learn more about DbSchema
KS DB Merge Tools
4.9 out of 5 stars
(11 Ratings)
KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of particular object type (table definitions, views, etc.), and then down to definition of particular object. Data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column.
Various diff results provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), ability to select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.
Learn more about KS DB Merge Tools
ChatDB
We all know SQL queries are like single-use plastics, you need it one time and don't use it again. Ask your database questions in natural language and ChatDB will write the SQL and answer your question. Database schemas can be complex, we try and make it easy for you to understand how everything is connected. You get a schema diagram right out of the box. No need to use a clunky database client to get a quick view of your data. Simple table interface with search built-in. We parse the AI-generated SQL query before executing it against the database to ensure it is a SELECT statement. However, to have 100% fool proof protection, we recommend creating a read-only account for ChatDB to use with the database.
Learn more about ChatDB