Database Management

MCP server for connecting AI assistants to Supabase projects

Supabase MCP is Supabase's Apache-2.0 server for connecting AI assistants to Supabase projects. It can expose database, configuration, and project-management workflows to MCP clients such as Cursor, Claude, and Windsurf, while the official docs emphasize permission and security review before production use, SQL changes, or high-privilege database access.

Database branching for coding agents

Ardent is a Postgres database branching platform built for coding-agent workflows. It creates isolated database copies in seconds so Claude Code, Codex, Cursor, or human developers can test migrations, clean data, reproduce bugs, and run risky experiments without touching production. The strongest fit is teams already using Postgres who need agent-safe dev/test databases rather than another generic serverless database.

AI-native database for hybrid RAG retrieval

Infinity is an AI-native database from InfiniFlow that unifies dense vectors, sparse vectors, tensors, and full-text search in a single engine. Built for retrieval-augmented generation (RAG) at scale, it powers hybrid search workflows where lexical matching, semantic similarity, and reranking all happen against one storage layer instead of four loosely coupled services.

In-process analytical SQL database

DuckDB is a high-performance analytical database that runs as an in-process SQL OLAP engine. Unlike traditional client-server databases, DuckDB embeds directly within your application, similar to SQLite but optimized for analytical queries. It supports complex SQL including window functions, CTEs, and nested types while processing columnar data with vectorized execution. DuckDB reads Parquet, CSV, JSON, and Arrow formats natively and integrates with Python and R data science workflows.

Lightweight open-source browser-based database GUI

Outerbase Studio is a lightweight, open-source database GUI that runs directly in your browser. It supports PostgreSQL, MySQL, and SQLite with a modern interface featuring intelligent query editor with auto-completion, multi-query execution, advanced data editing with staging and preview, and high-performance table rendering for thousands of rows. Also available as an Electron desktop client for databases requiring specialized drivers.

Instant database schema diagrams from a single query

ChartDB is an open-source database diagramming tool that converts SQL queries into instant visual entity-relationship diagrams. It supports PostgreSQL, MySQL, SQL Server, MariaDB, SQLite, CockroachDB, and ClickHouse, enabling database engineers to visualize schemas, plan migrations, and generate DDL scripts across different SQL dialects using AI assistance. Available as a free cloud app at chartdb.io or self-hosted via Docker deployment.

Multi-model database for the AI era — document, graph, vector, and relational in one

SurrealDB is a multi-model database that natively combines document, graph, relational, key-value, and vector storage in a single engine. It eliminates the need for separate databases by handling structured queries, graph traversals, full-text search, and vector similarity in one SQL-like query language called SurrealQL. Built in Rust for performance and safety, it supports real-time subscriptions, row-level permissions, and embedded or distributed deployment modes.

Git for data — version-controlled SQL database with branch, merge, and diff

Dolt is a SQL database that implements Git-style version control directly on structured data. Table changes can be staged, committed, branched, merged, diffed, and reverted through SQL workflows and a Git-like CLI. It speaks the MySQL wire protocol so existing MySQL clients, ORMs, and tools can connect with minimal driver changes. Dolt is used for AI training data management, reproducible analytics, collaborative data editing, and agent-memory experiments.

Conversational data analysis with natural language queries over databases

PandasAI enables natural-language queries against databases, data lakes, CSVs, and parquet files using LLMs and RAG pipelines. With 23,400+ GitHub stars, it bridges the gap between database tools and AI by letting developers and analysts interact with data conversationally, supporting SQL, PostgreSQL, and various file formats.

Financial transactions database designed for mission-critical safety and speed

TigerBeetle is a purpose-built database for financial transactions that prioritizes safety and performance above all else. Written in Zig, it provides strict debit-credit consistency, serializable isolation, append-only immutability, and multi-cloud high availability. Designed for ledgers, payment systems, and any application where losing or duplicating a transaction is catastrophic.

Auto-generates interactive ER diagrams from database schemas

Liam ERD automatically generates beautiful, interactive entity-relationship diagrams from existing database schemas. It supports Rails schema.rb, PostgreSQL, Prisma, and raw SQL — with zero configuration required. A web version handles public repos instantly, while the CLI processes private repositories with CI/CD integration for keeping documentation in sync.

Open data platform wrapping any SQL database with instant APIs

Directus is a database-first open data platform that wraps any existing SQL database with instant REST and GraphQL APIs, a no-code admin dashboard, and built-in authentication. Unlike traditional headless CMS platforms that impose their own data model, Directus introspects your existing schema and works on top of it — supporting PostgreSQL, MySQL, SQLite, MS SQL, MariaDB, and CockroachDB out of the box.

AI-native data application framework with SQL generation and agents

DB-GPT is an open-source AI-native data app framework combining SQL generation, database chat, RAG, and multi-agent orchestration for data-centric workflows. It supports natural language to SQL conversion, automated data analysis, and custom data app development. Integrates with MySQL, PostgreSQL, SQLite, and more. 19,000+ GitHub stars, MIT licensed. Positioned as an alternative to MindsDB for teams building AI-powered data applications and internal database tools.

Multi-database client with AI query optimization

DbVisualizer is a multi-database client with strong SQL editing, ER diagrams, and data management capabilities that has recently added AI assistants for query optimization. Consistently rated as a top-tier database GUI, it supports virtually every database engine and provides visual exploration, query profiling, and data comparison tools for developers and analysts working across diverse database environments.

Visual database designer with Git-integrated schemas

DbSchema is a visual database designer supporting 80+ SQL and NoSQL databases that features Git integration for schema version control, interactive HTML documentation generation, and AI-assisted query building. It provides the best visual approach to designing and maintaining database schemas in a version-controlled environment, bridging the gap between visual design and code-managed infrastructure.

Browser-based AI SQL editor with modern UX

Sheeta.ai is a browser-based AI SQL editor designed to modernize the data workflow with a simple, intuitive interface and high-accuracy query generation. It addresses the UX gaps of traditional database tools like DBeaver by providing a clean, modern interface with AI-powered query suggestions, schema visualization, and result exploration built for the contemporary data stack.

Governed analytics with a unified semantic layer

Querio turns plain English into SQL queries with a focus on governed analytics, connecting to live data warehouses and enforcing a unified semantic layer across the organization. It ensures that AI-generated queries remain consistent with business logic definitions, preventing the common problem where different teams get different answers to the same question from the same data.

Secure text-to-SQL with schema-only processing

Text2SQL.ai is a secure text-to-SQL platform that uses a schema-only model where actual database data never leaves the developer's infrastructure. It provides an affordable solution for teams building internal analytics tools with a public API for embedding SQL generation into custom applications, prioritizing data privacy for organizations in regulated industries.

Chat with your database in natural language

AskYourDatabase lets users chat with their databases using natural language, automatically generating SQL queries and visualizations from conversational questions. It autonomously creates dashboards and charts from queried data, serving as a self-serve reporting tool that reduces the business intelligence workload on engineering teams by letting non-technical users access data directly.

English-to-SQL with 100K+ users

AI2SQL converts plain English into optimized SQL queries with automatic schema detection, serving over 100,000 users worldwide. It features SQL explanation for learning, a formula generator for spreadsheets, and extensions for Slack and Chrome, providing a comprehensive ecosystem for non-technical users and developers who want to query databases faster using natural language input.

Multi-database AI query generator and optimizer

SQLAI.ai is a comprehensive AI toolkit for generating, optimizing, and explaining SQL queries across any database engine including both SQL and NoSQL systems. Supporting schemas with 600+ tables, it handles the full query lifecycle from natural language generation to performance optimization and cross-database migration, starting at $5/month as one of the most affordable AI SQL tools available.

AI schema generator from natural language

Structa is an AI tool that turns natural language descriptions into production-ready database schemas and SQL in under 45 seconds, focused on PostgreSQL and Supabase. Recognized as an editor's choice for AI schema generation, it is the fastest idea-to-schema tool available, generating optimized table structures, relationships, indexes, and constraints from plain English project requirements.

Open-source RAG-based text-to-SQL engine

Vanna AI is an MIT-licensed text-to-SQL and SQL-agent framework with 23.6K+ GitHub stars. Its current Vanna 2.0 story adds user-aware agents, access control, audit logs, streaming UI components, and optional hosted admin features for teams that need natural-language database access without locking into one LLM or database. The original repo is now archived, so verify the current Vanna 2.0 path before adoption.

AI tables inside your database with SQL

MindsDB is an open-source platform with 39K+ GitHub stars that lets developers combine machine learning predictions with standard SQL queries by federating data across 200+ sources. It enables creating AI models as virtual database tables, querying predictions with familiar SELECT statements, and building real-time ML pipelines without leaving the database workflow that teams already know.