DBeaver Community
5.0 out of 5 stars
(2 Ratings)
DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.
Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.)
SQL editor to create queries with syntax highlighting and autocompletion
AI assistant in SQL for building queries through natural language
SSL/TLS support for encrypted connections
SSH tunneling for secure remote access
Proxy configuration to work with databases behind a corporate firewall
Session Manager to terminate, disconnect, view and search for sessions
Lock Manager to monitor and manage database locks
Entity Relationship Diagrams to interactively explore and visualize database structure
Query manager to view all executed queries, including execution time, duration, affected rows, and errors.
Data editor to view, edit, and filter data
Learn more about DBeaver Community
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
HeidiSQL
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide. Free for everyone, OpenSource. Connect to multiple servers in one window. Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite. Connect to servers via commandline. Connect via SSH tunnel, or pass SSL settings. Create and edit tables, views, stored routines, triggers and scheduled events. Generate nice SQL-exports, compress these afterwards, or put them on the clipboard. Export from one server/database directly to another server/database. Manage user-privileges, import text-files, export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array. Browse and edit table-data using a comfortable grid.
Learn more about HeidiSQL
TablePlus
Modern, native client with intuitive GUI tools to create, access, query & edit multiple databases: MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Amazon Redshift, MariaDB, CockroachDB, Vertica, Cassandra, Snowflake, Oracle, Redis.
Learn more about TablePlus