Open-source alternatives to Sql Studio

Studio is a containerized SQL database management tool that provides a browser-based graphical interface for executing queries and managing data across various SQL databases. It consists of a specialized query editor and a graphical administration interface designed for web-based database administration. The project features a high-performance SQL query editor with auto-completion and function hints for running multiple database commands simultaneously. It includes a visual schema editor for creating and modifying table columns and a record editor that stages and previews changes before they

TablePlus is a SQL database management GUI and professional administration tool designed for managing relational and NoSQL databases. It functions as a native SQL query client and relational data browser, providing a graphical interface for database administration, schema management, and data exploration. The project distinguishes itself through a staged-change commit system that buffers GUI-driven modifications locally for review before they are applied to the server. It also features a native-protocol connection layer for low-latency communication and secure connectivity via SSH tunneling.

Harlequin is a terminal-based SQL IDE that runs queries against DuckDB and SQLite databases, with a plug-in adapter system for connecting to additional database engines. It provides a full-screen text editor with syntax highlighting and fuzzy autocomplete for writing SQL, and displays query results in a scrollable table within the terminal. The application distinguishes itself through a tree-based data catalog that lets you browse database schemas, local files, and remote S3 objects, with the ability to insert or copy paths directly into the query editor. It supports custom key bindings throu

Falcon is a cross-platform SQL client and database manager that provides a unified interface for executing queries across multiple database systems. It functions as a desktop application for Windows and Mac, allowing users to manage data across diverse database environments through a single query editor. The tool operates as a cloud-synced data studio, bridging the gap between local database results and remote cloud storage. This enables the transfer of processed query data to a cloud environment for persistent storage and collaborative analysis. Beyond query execution, the application inclu

A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi and Lazarus/FreePascal

CloudBeaver is a web-based database manager and cloud database IDE that provides a centralized browser interface for administering SQL and NoSQL databases. It functions as a multi-database administration tool and an RBAC database access gateway, allowing users to manage diverse relational and document-based database engines through a single server-based installation. The platform distinguishes itself by integrating an artificial intelligence assistant for natural language SQL generation and optimization. It further supports collaborative data engineering by coordinating database operations ac

Sqlectron-gui is a cross-platform database manager and SQL client. It provides a graphical interface for organizing server connections and executing SQL commands across various operating systems. The tool functions as a multi-database query environment, allowing users to connect to and interact with diverse relational database systems from a single interface. The application covers database server administration by saving and organizing connection details for multiple environments. It also includes capabilities for managing database connections and executing SQL queries.

Dev-Cpp is a comprehensive development suite that serves as a C++ integrated development environment, a cross-platform application builder, and a visual UI designer. It provides a toolchain for writing, compiling, and debugging native C++ applications on Windows, while offering a framework to create native binaries for desktop, mobile, and IoT devices from a single codebase. The project distinguishes itself by integrating an embedded SQL database engine and a REST API development platform directly into the workflow. It includes an AI-assisted coding tool that leverages large language models t

Briefer is an interactive data notebook platform and business intelligence dashboard tool used for collaborative data analysis and reporting. It provides a containerized environment for building reports that combine SQL, Python, and Markdown with native visualizations. The platform features an integrated code assistant that uses large language models to generate SQL and Python snippets from natural language prompts. It is designed as a Kubernetes data application, deploying via Helm charts to manage isolated compute environments and ensure separate resources per page through pod-based isolati

This project is a pure JavaScript database driver for Node.js that implements the native MySQL binary protocol. It serves as a comprehensive connector for managing persistent network links to MySQL servers, enabling applications to execute queries, manage transactions, and handle complex data operations without requiring external middleware. The driver distinguishes itself through its integrated support for connection pooling and distributed database routing. It maintains managed sets of reusable network sockets to optimize resource usage under high request volumes, while simultaneously provi

go-admin is a framework for generating administrative interfaces and data visualization dashboards using the Go programming language. It functions as a low-code dashboard builder and a web-based interface for performing create, read, update, and delete operations across multiple SQL database dialects. The project features a deployment model that compiles backend logic and frontend assets into a single executable binary for simplified distribution. It includes a role-based access control system to manage user permissions and restrict administrative functions based on assigned roles. The frame

dsq is a command-line interface and data engine for executing SQL queries against local structured files, such as CSV, JSON, Parquet, and Excel, without requiring a formal database import. It functions as a schema-inference engine that automatically detects data types and maps heterogeneous file structures into relational tables for analysis. The tool utilizes a lazy stream data processor and checksum-based disk caching to handle large datasets with minimal memory usage. It provides a persistent interactive shell for iterative data exploration, allowing users to inspect inferred schemas and r

sql.js is a serverless, in-memory SQL database engine that ports SQLite to WebAssembly for use within a web browser. It provides a JavaScript interface to initialize relational databases, execute SQL queries, and manage structured data without requiring a backend server. The project enables the import and export of database states using typed arrays, allowing in-memory data to be persisted as files. It supports high-precision integer retrieval via BigInt and utilizes prepared statements to increase execution speed and security. The engine includes capabilities for client-side data management

whodb is a multi-database management interface and notebook client designed for exploring and managing data across various engines, including Postgres, MySQL, MongoDB, and Redis. It functions as a graphical interface for managing database connections, records, and schemas through a unified layer. The project features a natural language query interface that uses large language models to translate plain English into executable SQL or NoSQL queries. This is supported by schema-aware prompting that injects database metadata into the model context to ensure generated queries match actual table def

sql-mother is a browser-based educational platform for learning SQL syntax through interactive exercises, tutorials, and a query playground. It provides a structured environment for mastering the logic and syntax of MySQL, SQLite, and PostgreSQL using a sequence of hands-on challenges. The platform uses a WebAssembly-based database engine to enable local SQL execution and real-time query validation entirely within the browser. This architecture allows for virtual table mocking and state management without the need for a backend server or user accounts. The environment includes a gamified cur

SQLiteStudio is an open-source graphical tool for browsing, editing, and managing SQLite database files. It combines a full-featured SQL editor with syntax highlighting, a visual database schema designer for creating entity-relationship diagrams, and a plugin-based extensibility platform that allows adding custom functionality through C/C++, JavaScript, Tcl, or Python. The application distinguishes itself through its multi-language scripting engine, which embeds JavaScript, Tcl, and Python interpreters to enable user-defined functions and scripts within SQL queries. It supports encrypted data

Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL. The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions. The capability surface inc

cr-sqlite is a multi-master database replication system that uses conflict-free replicated data types to ensure eventual consistency across distributed nodes. It provides the core capabilities for offline-first data synchronization, allowing multiple database instances to merge concurrent updates and reach a consistent state. The project distinguishes itself through a combination of CRDT-based data replication and a WASM-based database engine, enabling full SQL execution and state persistence within web browsers. It supports peer-to-peer replication and cross-tab synchronization, utilizing ca

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

Beekeeper Studio is a cross-platform desktop application designed for database management and SQL development. It provides a unified graphical interface to connect to, query, and modify data across a wide range of relational and NoSQL database systems. The application functions as a comprehensive workspace, integrating tools for schema design, record editing, and data visualization. The project distinguishes itself through a focus on secure, flexible connectivity and AI-assisted workflows. It supports advanced authentication methods, including enterprise single sign-on, multi-factor authentic

This extension provides a unified graphical interface for managing relational and NoSQL databases directly within the code editor. It serves as a comprehensive environment for database lifecycle support, enabling users to browse schemas, execute custom queries, and perform administrative tasks across multiple server types. The tool distinguishes itself through integrated support for secure connectivity, including SSH tunneling and SSL certificate management, alongside automated schema documentation and visualization capabilities. It facilitates complex data operations by wrapping external com

AliSQL is a fork of MySQL by Alibaba that extends the relational database management system with enhancements for high performance, scalability, and enterprise-grade availability. It retains the core MySQL identity as a SQL-based database for storing, organizing, and retrieving structured data, while adding optimizations for large-scale transactional and analytical workloads. The project differentiates itself through a set of Alibaba-specific improvements, including a columnar engine for accelerating analytical queries directly on MySQL tables, and a distributed, shared-nothing NDB Cluster en

xo is a tool for generating type-safe Go models and query execution code from SQL database schemas and queries. It functions as a multi-dialect SQL tool supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server to produce idiomatic source code. The project uses a template-based generation system, allowing the structure and logic of the generated database source code to be defined through customizable text templates. It also includes a database schema visualizer that analyzes table relationships and definitions to create visual diagrams and structured documentation. The tool's ca

CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web applications. It provides a lightweight toolkit with minimal configuration, organizing application logic into controllers, models, and views for clean separation of concerns. The framework includes a fluent query builder for constructing SQL statements programmatically, PSR-4 autoloading with namespace mapping, and a service-based dependency injection container for managing shared class instances. The framework distinguishes itself through its comprehensive set of built-in tools

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

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

Kùzu is an embedded property graph database engine designed for high-performance analytical queries and local data management. It operates as a library within the host application process, utilizing a columnar-based storage architecture and just-in-time query compilation to execute complex graph traversals and pattern matching efficiently. By mapping database files directly into system memory, it ensures data durability and high-speed access while maintaining ACID-compliant transactional integrity. The engine distinguishes itself by integrating vector similarity search and full-text search di