# Multi-Engine Desktop SQL Clients

> Search results for `desktop SQL client for Postgres MySQL and SQLite` on awesome-repositories.com. 113 total matches; showing the first 50.

Explore on the web: https://awesome-repositories.com/q/desktop-sql-client-for-postgres-mysql-and-sqlite

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [this search on awesome-repositories.com](https://awesome-repositories.com/q/desktop-sql-client-for-postgres-mysql-and-sqlite).**

## Results

- [ottermind/chat2db](https://awesome-repositories.com/repository/ottermind-chat2db.md) (25,784 ⭐) — Chat2DB is an AI-powered SQL client and multi-database GUI manager designed for managing various relational and NoSQL database systems. It serves as a visual database management tool and a natural language to SQL interface, allowing users to convert plain text descriptions into executable and optimized queries.

The platform distinguishes itself through automated business intelligence capabilities, which include the generation of real-time data visualization dashboards and AI-driven data analysis from spreadsheets. To ensure data privacy, it supports secure local AI deployment, enabling large
- [clickhouse/clickhouse](https://awesome-repositories.com/repository/clickhouse-clickhouse.md) (48,229 ⭐) — ClickHouse is a high-performance, columnar analytical database designed for real-time query execution and large-scale data aggregation. It functions as a distributed data warehouse capable of processing petabytes of information, while also providing an embedded engine that integrates directly into applications for native query capabilities without external dependencies. The system is built to handle high-throughput ingestion and complex analytical workloads, delivering millisecond-level latency for interactive dashboards and operational monitoring.

The platform distinguishes itself through ad
- [cube-js/cube](https://awesome-repositories.com/repository/cube-js-cube.md) (20,251 ⭐) — Cube is a semantic data layer that provides a unified framework for defining business metrics, dimensions, and relationships across diverse data sources. By acting as a headless business intelligence engine, it transforms raw data into a governed model that can be queried via SQL, REST, and GraphQL interfaces. This architecture ensures consistent data definitions and logic across all downstream analytical applications and reporting tools.

The platform distinguishes itself through its integrated conversational AI capabilities, which allow users to explore data using natural language. It orches
- [cockroachdb/cockroach](https://awesome-repositories.com/repository/cockroachdb-cockroach.md) (32,207 ⭐) — Cockroach is a distributed SQL database designed to scale horizontally across multiple nodes while maintaining strict ACID compliance and global data consistency. It functions as a relational database engine that automatically partitions data into ranges, rebalancing them across a cluster to accommodate growing storage and throughput requirements. By utilizing a distributed consensus protocol, the system ensures that all nodes agree on the order of operations, providing fault tolerance and continuous availability even in the event of hardware failures.

The system distinguishes itself through
- [kennethreitz/records](https://awesome-repositories.com/repository/kennethreitz-records.md) (7,217 ⭐) — Records is a SQL database client designed for executing raw queries and managing result sets through a simplified interface. It provides a parameterized SQL executor to bind values to placeholders, ensuring safe data handling and preventing injection attacks, alongside a database transaction manager for grouping operations into atomic units.

The project includes a dedicated command-line interface for running database statements and exporting query results directly to local files. This tooling allows for the conversion of SQL result sets into multiple serialization formats, including CSV, JSON
- [prisma/prisma](https://awesome-repositories.com/repository/prisma-prisma.md) (46,366 ⭐) — Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations.

The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o
- [mysql/mysql-server](https://awesome-repositories.com/repository/mysql-mysql-server.md) (12,297 ⭐) — MySQL Server is a relational database management system designed to organize and store structured information. It functions as a comprehensive SQL server platform that provides reliable transactional integrity and high-performance query execution for enterprise data management.

The system distinguishes itself through a pluggable storage engine architecture that decouples logical query processing from physical data storage, allowing for specialized handling of diverse workloads. It maintains data consistency and high concurrency through multi-version concurrency control and write-ahead logging
- [electric-sql/pglite](https://awesome-repositories.com/repository/electric-sql-pglite.md) (14,707 ⭐) — Pglite is a client-side relational database engine that runs a full-featured PostgreSQL instance directly within browser and Node.js environments. By leveraging WebAssembly, it provides a persistent SQL storage solution that enables complex data management and querying without requiring an external database server.

The project distinguishes itself through a reactive SQL data layer that automatically synchronizes user interface components with live query results. It manages database operations using worker threads to prevent main-thread blocking and coordinates access across multiple browser t
- [mysql/mysql-shell](https://awesome-repositories.com/repository/mysql-mysql-shell.md) (222 ⭐) — MySQL Shell is a command line scriptable shell for MySQL, with support for logical backups, InnoDB Cluster management and more. It supports SQL, JavaScript and Python.
- [maxteabag/sqlit](https://awesome-repositories.com/repository/maxteabag-sqlit.md) (3,702 ⭐) — Sqlit is a terminal-based SQL client and database explorer designed for executing queries and managing database connections. It functions as a command line interface that provides syntax highlighting, command history, and a terminal user interface for rendering results.

The tool features a discovery engine that scans local Docker sockets to automatically identify and resolve connection details for active database containers. It handles secure access through encrypted SSH tunnels and integrates with external secrets managers to retrieve credentials.

The project includes capabilities for data
- [mysql-otp/mysql-otp](https://awesome-repositories.com/repository/mysql-otp-mysql-otp.md) (375 ⭐) — MySQL/OTP – MySQL and MariaDB client for Erlang/OTP
- [oven-sh/bun](https://awesome-repositories.com/repository/oven-sh-bun.md) (93,257 ⭐) — Bun is a high-performance runtime environment designed to execute JavaScript and TypeScript applications with minimal latency and high throughput. Built on a native core implemented in Zig, it provides a unified execution engine that leverages JavaScriptCore for efficient memory management and low-latency startup. The project functions as an all-in-one toolchain, integrating a native bundler, transpiler, package manager, and test runner into a single command-line interface.

What distinguishes Bun is its focus on native system integration and developer productivity. It features a high-performa
- [sqlite/sqlite](https://awesome-repositories.com/repository/sqlite-sqlite.md) (9,909 ⭐) — SQLite Source Repository
- [drizzle-team/drizzle-orm](https://awesome-repositories.com/repository/drizzle-team-drizzle-orm.md) (34,835 ⭐) — Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.
- [mysql/mysql-workbench](https://awesome-repositories.com/repository/mysql-mysql-workbench.md) (990 ⭐) — MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.
- [doctrine/dbal](https://awesome-repositories.com/repository/doctrine-dbal.md) (9,699 ⭐) — This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa.

The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between
- [dhamaniasad/awesome-postgres](https://awesome-repositories.com/repository/dhamaniasad-awesome-postgres.md) (11,955 ⭐) — This project is a curated directory of software, libraries, and resources designed to support the management, monitoring, and deployment of PostgreSQL database environments. It functions as a structured index of community-supported tools, providing a centralized location for users to discover utilities that enhance database functionality and reliability.

The directory organizes disparate database solutions into a logical hierarchy, covering areas such as graphical interfaces, backup and recovery utilities, and performance monitoring platforms. By categorizing these resources, it assists in th
- [go-sql-driver/mysql](https://awesome-repositories.com/repository/go-sql-driver-mysql.md) (15,424 ⭐) — This project is a native Go driver for the MySQL protocol, providing a communication layer that enables applications to interact with relational database management systems. It implements the standard database interface, allowing developers to manage persistent connections, execute queries, and handle transactions within their applications.

The driver functions by translating high-level database commands into the specific binary packet format required for communication with MySQL servers. It manages network sessions through a connection pooling mechanism and supports context-aware query cance
- [eclipse-vertx/vert.x](https://awesome-repositories.com/repository/eclipse-vertx-vert-x.md) (14,667 ⭐) — Vert.x is a reactive polyglot framework and asynchronous programming library for the Java Virtual Machine. It functions as an event-driven networking framework and toolkit for building non-blocking applications.

The system enables the development of high-concurrency network services and event-driven microservices. It supports the creation of reactive services using multiple languages running on the JVM.

The framework covers a wide range of capabilities including the management of HTTP and TCP network protocols, non-blocking file system access, and the integration of reactive clients.
- [guoyu511/vertx-mysql-binlog-client](https://awesome-repositories.com/repository/guoyu511-vertx-mysql-binlog-client.md) (16 ⭐) — A Vert.x client for tapping into MySQL replication stream. Based on Vert.x 3.4.1.
- [dbcli/mycli](https://awesome-repositories.com/repository/dbcli-mycli.md) (11,932 ⭐) — mycli is a MySQL command line client, database administration tool, and SQL query editor. It functions as a terminal interface for executing queries and managing MySQL connections, incorporating an integrated assistant that uses large language models to generate and analyze SQL statements based on the current database schema.

The tool provides specialized query authoring capabilities, including context-sensitive syntax suggestions, fuzzy-matching identifier completion for tables and columns, and the ability to handover query buffers to external system text editors. It distinguishes its connec
- [eclipse-vertx/vertx-sql-client](https://awesome-repositories.com/repository/eclipse-vertx-vertx-sql-client.md) (911 ⭐) — High performance reactive SQL Client written in Java
- [harelba/q](https://awesome-repositories.com/repository/harelba-q.md) (10,353 ⭐) — q is a command-line utility for the processing, filtering, and aggregation of tabular text and database files using standard SQL syntax. It functions as a query engine that treats CSV and TSV files, as well as standard input, as relational database tables.

The tool distinguishes itself by providing a persistent cache layer that stores processed tabular data in a binary format to accelerate repeated queries on large datasets. It also maps individual filenames or stream identifiers to relational table names, enabling SQL joins across disparate text files.

The project covers a broad range of da
- [atuinsh/atuin](https://awesome-repositories.com/repository/atuinsh-atuin.md) (30,266 ⭐) — Atuin is a command-line tool that replaces standard shell history with a searchable, encrypted SQLite database. By hooking into shell initialization scripts, it provides an interactive, keyboard-driven interface for real-time command filtering and retrieval. The platform ensures data privacy through a client-side encryption layer, securing sensitive history and configuration data before it is synchronized across multiple machines.

Beyond history management, Atuin functions as an executable documentation platform that enables teams to create and share interactive runbooks. These documents use
- [huanshankeji/exposed-vertx-sql-client](https://awesome-repositories.com/repository/huanshankeji-exposed-vertx-sql-client.md) (10 ⭐) — Execute Exposed statements with Vert.x Reactive SQL Client
- [gofr-dev/gofr](https://awesome-repositories.com/repository/gofr-dev-gofr.md) (21,321 ⭐) — Gofr is a comprehensive framework for building production-ready microservices in Go. It provides a unified toolkit for developing RESTful APIs and gRPC services, offering built-in support for observability, database management, and distributed system communication.

The framework distinguishes itself through its focus on developer productivity and system resilience. It automates common backend tasks such as CRUD handler generation, schema-driven code creation, and database migration orchestration, while preventing race conditions in clustered environments. To maintain stability, it includes in
- [achristmascarl/rainfrog](https://awesome-repositories.com/repository/achristmascarl-rainfrog.md) (4,855 ⭐) — Rainfrog is a terminal-based database client that connects to multiple database engines, combining schema browsing, interactive SQL query execution, and inline data editing into a single terminal interface. It provides a tree navigator for exploring tables, columns, and indexes, and an inline cell editor that automatically constructs and executes the necessary UPDATE statements when a cell value is changed. The application also supports modal Vim-style keyboard shortcuts for cursor movement and editing, making it usable entirely from the keyboard.

Query results are fetched in chunks and pagin
- [dbeaver/dbeaver](https://awesome-repositories.com/repository/dbeaver-dbeaver.md) (50,678 ⭐) — DBeaver is a universal database client and administration environment designed for managing diverse relational and non-relational database systems. It provides a unified graphical interface that enables users to perform data manipulation, schema migration, and performance monitoring across multiple platforms. By utilizing a standardized driver abstraction layer, the application translates generic requests into database-specific commands, ensuring consistent interaction regardless of the underlying technology.

The project distinguishes itself through an extensible, plugin-based architecture th
- [liyupi/sql-mother](https://awesome-repositories.com/repository/liyupi-sql-mother.md) (4,215 ⭐) — 程序员鱼皮原创项目，免费的闯关交互式 SQL 自学教程网站，从零基础到进阶，带你掌握常用 SQL 语法（MySQL、SQLite、PostgreSQL）、快速学习 SQL 和数据库。支持在线SQL编辑器、实时查询结果、语法高亮、SQL运行广场等功能。纯前端实现，简单易学~
- [agno-agi/agno](https://awesome-repositories.com/repository/agno-agi-agno.md) (40,717 ⭐) — Agno is an agent operating system designed to manage the lifecycle, tool execution, and persistent state of autonomous agents across distributed infrastructure. It provides a unified runtime environment that wraps diverse agent frameworks into a consistent, interoperable protocol, allowing developers to build and deploy complex multi-agent systems that coordinate tasks and delegate sub-processes.

The platform distinguishes itself through a robust governance and orchestration layer that includes human-in-the-loop approval gates, role-based access control, and a centralized API gateway. It feat
- [hautdefrance/web-gui-for-sqlite](https://awesome-repositories.com/repository/hautdefrance-web-gui-for-sqlite.md) (45 ⭐) — Web GUI for SQLite is a web-based SQLite browser written in JavaScript.
- [qishibo/anotherredisdesktopmanager](https://awesome-repositories.com/repository/qishibo-anotherredisdesktopmanager.md) (34,430 ⭐) — This project is a cross-platform desktop application that provides a graphical interface for managing and interacting with Redis databases. Built as a standalone software program, it functions as a centralized connection manager that allows users to visualize data structures, perform administrative tasks, and inspect records across multiple database environments.

The application distinguishes itself through its integration with external processes and command-line workflows. Users can define custom viewers to render specific data formats using external tools and launch the interface directly f
- [mindsdb/mindsdb](https://awesome-repositories.com/repository/mindsdb-mindsdb.md) (39,313 ⭐) — MindsDB is an AI-native database engine that treats machine learning models and autonomous agents as virtual tables. By mapping external data sources, predictive models, and third-party services directly into the database schema, it enables users to perform inference, data retrieval, and complex orchestration using standard SQL syntax.

The platform distinguishes itself through an autonomous agent orchestrator that executes iterative reasoning loops, allowing agents to plan data access and synthesize natural language responses from connected knowledge bases. It functions as a federated data ga
- [sequel-ace/sequel-ace](https://awesome-repositories.com/repository/sequel-ace-sequel-ace.md) (7,440 ⭐) — Sequel Ace is a native macOS application that serves as a management client for MySQL and MariaDB database instances. It provides a graphical user interface for executing SQL queries and administering database structures without the use of a command line.

The project enables the visualization of relational database structures and records in a visual format. It includes a visual query editor and data browser for writing and executing SQL statements to retrieve or modify data.

The application handles database administration tasks and data storage through a native desktop interface. It manages
- [fuyoo/bs-redis-desktop-client](https://awesome-repositories.com/repository/fuyoo-bs-redis-desktop-client.md) (332 ⭐) — A redis desktop client based on Tauri.
- [wheelibin/qrypad](https://awesome-repositories.com/repository/wheelibin-qrypad.md) (32 ⭐) — A terminal SQL client for Postgres, MySQL and SQLite.
- [vrana/adminer](https://awesome-repositories.com/repository/vrana-adminer.md) (7,432 ⭐) — Adminer is a PHP-based database management tool and multi-engine database client. It provides a web-based graphical interface for administering various relational and document database engines.

The application is distributed as a single file to simplify installation and deployment on web servers. It supports customization through external stylesheets for visual themes and a plugin architecture to extend core functionality and system behaviors.

The tool covers database schema administration, including the creation of views and management of foreign keys. It includes a SQL query editor with au
- [payloadcms/payload](https://awesome-repositories.com/repository/payloadcms-payload.md) (43,053 ⭐) — Payload is a headless content management system and application framework that uses a code-first approach to define data schemas and administrative interfaces. By utilizing a centralized, type-safe configuration object, it automatically generates database schemas, API endpoints, and a fully customizable admin panel. The system is built on a database-agnostic architecture, allowing it to interface with various storage engines while providing a unified, type-safe API for server-side operations, REST, and GraphQL.

What distinguishes Payload is its deep extensibility and developer-centric design.
- [mysql/mysql-connector-python](https://awesome-repositories.com/repository/mysql-mysql-connector-python.md) (954 ⭐) — MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python. No MySQL libraries are needed, and no compilation is necessary to run this Python DB API v2.0 compliant driver. Documentation & Download: http://dev.mysql.com/doc/connector-python/en
- [sidneys/pb-for-desktop](https://awesome-repositories.com/repository/sidneys-pb-for-desktop.md) (518 ⭐) — The missing Desktop application for Pushbullet.
- [apache/superset](https://awesome-repositories.com/repository/apache-superset.md) (73,451 ⭐) — Superset is a web-based business intelligence platform designed for data exploration, visualization, and interactive dashboarding. It functions as a query-driven analytics engine that connects to various SQL databases, allowing users to perform ad-hoc analysis, define virtual metrics, and build complex data visualizations through a centralized interface.

The platform distinguishes itself through a robust semantic layer that transforms raw database schemas into calculated columns and virtual metrics, enabling consistent business logic across an organization. It features a plugin-based visualiz
- [chat2db/chat2db](https://awesome-repositories.com/repository/chat2db-chat2db.md) (25,762 ⭐) — Chat2DB is an AI-powered SQL client and multi-database management GUI. It serves as a centralized graphical interface for administering diverse relational and non-relational database engines, integrating large language models to transform natural language prompts into executable SQL statements and application code.

The tool utilizes schema-aware prompt engineering to inject database metadata into AI requests, ensuring generated queries match the actual schema. It also functions as an AI data reporting tool, using artificial intelligence to create dashboards and visual reports directly from da
- [mysql/mysql-sys](https://awesome-repositories.com/repository/mysql-mysql-sys.md) (827 ⭐) — The MySQL sys schema
- [dbcli/pgcli](https://awesome-repositories.com/repository/dbcli-pgcli.md) (13,231 ⭐) — pgcli is an interactive command-line interface and database management tool for PostgreSQL. It functions as an interactive SQL shell and query editor that allows users to inspect schemas, manage connections, and run queries against PostgreSQL data sources.

The tool is distinguished by its real-time, schema-aware autocompletion for keywords, tables, and columns, as well as dynamic SQL syntax highlighting. It provides safety mechanisms through transaction-aware guardrails that warn against or block destructive statements when no active transaction is detected.

Broad capabilities include secure
- [postgres/postgres](https://awesome-repositories.com/repository/postgres-postgres.md) (20,076 ⭐) — PostgreSQL is an object-relational database management system designed for the persistent storage and retrieval of structured information. It functions as an ACID-compliant database server, utilizing standard query language protocols to maintain data consistency and reliability across large-scale application datasets.

The system distinguishes itself through an extensible architecture that allows for the definition of custom data types, operators, and indexing methods. It employs multi-version concurrency control to enable simultaneous read and write operations without blocking, supported by a
- [alasql/alasql](https://awesome-repositories.com/repository/alasql-alasql.md) (7,278 ⭐) — AlaSQL is a JavaScript SQL database engine that allows for the filtering, grouping, and joining of in-memory object arrays and JSON data. It functions as an in-memory SQL database and client-side data processor, enabling the execution of SQL statements against JavaScript arrays and external data sources in both browser and server environments.

The project serves as a universal data query tool capable of performing relational joins across diverse sources, such as merging Google Spreadsheets, SQLite files, and remote APIs into a single result set. It also acts as an IndexedDB SQL wrapper, allow
- [sequelize/sequelize](https://awesome-repositories.com/repository/sequelize-sequelize.md) (30,349 ⭐) — Sequelize is an object-relational mapping library that provides a unified interface for managing relational data through code. By implementing the Active Record pattern, it maps database tables to application objects, allowing developers to perform standard create, read, update, and delete operations using high-level method calls. The library abstracts complex database interactions by translating these calls into optimized, engine-specific SQL statements, ensuring consistent behavior across different database systems.

The project distinguishes itself through a comprehensive suite of tools for
- [duckdb/duckdb](https://awesome-repositories.com/repository/duckdb-duckdb.md) (38,805 ⭐) — DuckDB is an in-process analytical database engine designed to run directly within an application process. As a zero-dependency, embedded system, it provides enterprise-grade SQL data processing capabilities without the overhead of managing a dedicated database server. It is built to handle complex analytical and aggregation tasks by storing and retrieving information in columns, allowing for high-performance relational data manipulation.

The engine distinguishes itself through a columnar vectorized execution model that maximizes CPU cache efficiency during query operations. It employs adapti
- [mysql/mysql-connector-cpp](https://awesome-repositories.com/repository/mysql-mysql-connector-cpp.md) (704 ⭐) — MySQL Connector/C++ is a MySQL database connector for C++. It lets you develop C++ and C applications that connect to MySQL Server.
- [xo/usql](https://awesome-repositories.com/repository/xo-usql.md) (10,014 ⭐) — usql is a universal SQL command-line interface used to connect to and manage multiple SQL and NoSQL databases through a single unified tool. It provides a standardized interface for executing queries across various data stores and serves as a multi-database query tool and schema inspector.

The tool distinguishes itself by enabling cross-database data migration, allowing users to pipe result sets from one active database connection directly into another. It also features terminal-based data visualization, which renders query results as graphical charts, graphs, and images directly within the t
