Databases & ORMs

Serverless Postgres

Serverless Postgres platform separating storage and compute for branching, autoscaling, read replicas, instant restore, and scale-to-zero workloads. Neon works with standard PostgreSQL clients and ORMs, supports extensions such as pgvector, and sits inside a broader Neon backend platform with Auth, Data API, Functions, Object Storage, and AI Gateway features.

The open-source Firebase alternative

Open-source Firebase alternative providing a full backend-as-a-service on PostgreSQL. Auto-generated REST and GraphQL APIs from your schema, real-time subscriptions, built-in auth with 20+ social providers and Row Level Security, S3-compatible file storage with CDN, and Deno-powered Edge Functions. Visual dashboard with SQL editor and table editor. Supports pgvector for AI apps. Self-hostable or managed with a generous free tier. 75K+ GitHub stars.

TypeScript ORM that feels like SQL

Lightweight, serverless-ready TypeScript ORM with zero dependencies bringing SQL-like syntax into TypeScript for maximum type-safety. Maps queries closely to raw SQL with full auto-completion and type inference. Features Drizzle Kit for migrations, Drizzle Studio for visual browsing, supports PostgreSQL, MySQL, SQLite, and Turso. Runs on Node.js, Bun, Deno, Cloudflare Workers, and Vercel Edge. 26K+ GitHub stars, growing fast as a Prisma alternative.

High-performance vector database written in Rust for similarity search at scale.

Qdrant is a high-performance vector similarity search engine and database written in Rust. Designed for production-grade AI applications with advanced filtering, payload indexing, and distributed deployment. Supports billion-scale vector collections with sub-second query times. Popular choice for RAG, recommendation systems, and anomaly detection.

Fully managed vector database built for AI applications at production scale.

Pinecone is a leading managed vector database designed for high-performance similarity search at scale. Purpose-built for AI applications including RAG, recommendation systems, and semantic search. Offers managed serverless infrastructure with automatic scaling, filtering, hybrid retrieval, and namespacing. No infrastructure management required.

Embedded vector database for multimodal AI with petabyte scale

LanceDB is an open-source embedded vector database built on the Lance columnar format for multimodal AI. It delivers near in-memory performance from disk with zero-copy architecture, supporting vector search, full-text search, and SQL. Native SDKs for Python, TypeScript, and Rust integrate with LangChain, LlamaIndex, and DuckDB. Backed by a $30M Series A, used by Harvey AI and Runway, with 18,000+ GitHub stars.

Fully managed RAG-as-a-Service platform for enterprise AI applications

Ragie is a managed retrieval-augmented generation platform that handles document ingestion, indexing, and retrieval so developers can build grounded AI applications without managing vector databases or chunking pipelines. It connects to Google Drive, Notion, Slack, Confluence, and other enterprise data sources with simple APIs for hybrid search and entity extraction.

High-recall Postgres vector search at billion scale

VectorChord is a Postgres extension from the supervc-stack/VectorChord project that brings high-recall vector search to PostgreSQL. As the spiritual successor to pgvecto.rs, it combines IVF indexes with RaBitQ quantization to deliver Pinecone-class performance at billion-vector scale while keeping all data inside a single Postgres database — no separate vector store, no two-system sync, no rewrites when the workload grows.

Vector similarity search for PostgreSQL

pgvector is an open-source PostgreSQL extension with 22K+ GitHub stars adding vector similarity search to your existing Postgres database. Store embeddings alongside relational data, perform exact and approximate nearest neighbor search using L2, inner product, cosine, and L1 metrics. Supports HNSW and IVFFlat indexes for fast similarity queries at scale. Eliminates the need for a separate vector database by bringing vector capabilities into existing PostgreSQL infrastructure.

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.

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.

Next-generation Node.js ORM

Next-generation TypeScript ORM with schema-first design and auto-generated, type-safe database client. Define models in Prisma Schema Language, manage migrations via Prisma Migrate, and browse data in Prisma Studio. Supports PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB. Prisma Accelerate provides edge caching and connection pooling, Optimize offers AI-powered query analysis. 40K+ GitHub stars, widely adopted in Node.js/TypeScript.

Open-source high-performance key/value datastore

Valkey is a Linux Foundation-backed, BSD-3-Clause open-source fork of Redis 7.2.4 for caching, queues, and real-time data workloads. Current 9.1 and 8.1.8 releases continue performance, security, module, and cluster work while preserving Redis-compatible migration paths. It has 26K+ GitHub stars and managed-service support from AWS, Google, Oracle, Ericsson, and others.

Open-source vector database for AI-native applications and semantic search.

Weaviate is an open-source vector database purpose-built for AI applications. Supports vector, keyword, and hybrid search with built-in vectorization modules for OpenAI, Cohere, Hugging Face, and more. Used for RAG pipelines, semantic search, recommendation engines, and multimodal search. Written in Go for high performance.

Open-source embedding database — the AI-native way to store and query embeddings.

Chroma is an open-source embedding database designed for simplicity and developer experience. Runs in-memory, as a Python library, or as a client-server deployment. Popular for prototyping RAG applications, local development, and lightweight vector search. Integrates natively with LangChain, LlamaIndex, and OpenAI.

Distributed search and analytics engine for all types of data.

Elasticsearch is the world's most popular open-source search and analytics engine, powering search experiences for companies like Wikipedia, GitHub, Netflix, and Uber. Built on Apache Lucene, it provides near-real-time search, structured and unstructured data analysis, and machine learning capabilities. Part of the Elastic Stack (ELK), it handles log analytics, application search, security analytics, and observability at scale. Supports vector search for AI/RAG applications.

Google’s app development platform for backend, auth, database, hosting, analytics, and AI features

Firebase is Google’s app development platform providing backend services including Firestore, Realtime Database, Authentication, Cloud Storage, Cloud Functions, Hosting, Analytics, messaging, and AI-connected app features. Current docs foreground Firebase AI Logic for Gemini API access, Genkit for full-stack AI and agentic apps, Firestore vector search, and SQL Connect. Spark plan is free; Blaze is pay-as-you-go.

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.

GPU-accelerated open-source vector database

Milvus is an open-source vector database with 45K+ GitHub stars for billion-scale similarity search. Features GPU-accelerated indexing, hybrid search combining vector and scalar filtering, multi-tenancy, partitioning, and horizontal scaling. Supports HNSW, IVF, DiskANN, and GPU index types. SDKs for Python, Java, Go, and Node.js. Zilliz Cloud offers a managed version. A production-grade foundation for RAG pipelines and recommendation systems at enterprise scale.

DiskANN-powered vector search extension for PostgreSQL

pgvectorscale is an open-source PostgreSQL extension from Timescale that complements pgvector with DiskANN-based approximate vector search. It is useful for teams that want faster embedding retrieval while keeping vectors, filters, and application data inside the Postgres ecosystem instead of adopting a separate hosted vector database.

Serverless vector and full-text search on object storage

turbopuffer is a serverless vector and full-text search engine built on object storage and vendor-positioned as roughly 10x cheaper than traditional vector databases. Used by Anthropic, Cursor, Notion, and Atlassian for production search workloads. Official site reports 4T+ documents, 10M+ writes/s, and 25k+ queries/s in production systems. Funded by Thrive Capital.

Open-source search engine with vector and hybrid retrieval

OpenSearch is an Apache-2.0 distributed search engine with native vector-search support for teams that want BM25, filters, aggregations, and k-NN retrieval in the same search stack. It is distinct from Elasticsearch in the aicoolies catalog: OpenSearch is the AWS-backed open fork with its own docs, plugin path, and serverless deployment options.

MySQL-compatible serverless database

Relational database platform for MySQL and Postgres with Vitess-backed MySQL scale, PlanetScale Postgres, query insights, deploy-request workflows, and Database Traffic Control. It fits production teams that need managed relational performance, safe schema changes, replicas, and database expertise rather than a simple hobby database.

Hybrid search and ML ranking engine at scale

Vespa is an open-source serving engine with 6K+ GitHub stars for hybrid search combining vector similarity, BM25 text ranking, and structured filtering in a single query. Built by Yahoo for web-scale, it handles billions of documents with millisecond latency. Features real-time indexing, ML model serving, tensor computation, and ACID-compliant writes. Supports custom ranking models, query federation, and geographic search. Used for recommendation systems, personalization, and RAG.

Library for efficient similarity search and clustering of dense vectors at billion-scale.

FAISS is Meta AI Research's open-source library for efficient similarity search and clustering of dense vectors. It implements approximate nearest-neighbor algorithms designed to scale to billions of vectors, with optimized indexes that fit in RAM and GPU acceleration for the largest workloads. Engineering teams use FAISS as the retrieval primitive underneath custom RAG pipelines, recommendation systems, and large-scale embedding search infrastructure.

Serverless vector database with pay-as-you-go API pricing

Upstash Vector is a managed serverless vector database for RAG, semantic search, and embedding lookup. It is separate from the existing Upstash platform record in the aicoolies catalog: this slug covers the Vector product line, not the broader Redis, Kafka, or QStash platform.

Edge-native vector database for Workers and AI applications

Cloudflare Vectorize is Cloudflare’s managed vector database for Workers and edge AI applications. It is distinct from the existing Cloudflare Workers tool page: Workers is the compute runtime, while Vectorize is the embedding index and vector-query layer used to add semantic retrieval to Cloudflare-hosted apps.

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.

Federated SQL and semantic search across live data for AI agents

MindsDB Query Engine is a self-hosted, SQL-compatible federated query layer for AI agents. It connects live databases, warehouses, SaaS apps, documents, and vector stores without requiring a separate ETL pipeline; adds knowledge bases for semantic and hybrid retrieval; and exposes the result through SQL, MCP, HTTP, and MySQL/PostgreSQL-compatible interfaces. It is separate from MindsHub, the same team's hosted agent workspace.

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.

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.

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.

ELT platform with 350+ data connectors

Airbyte is an ELT platform with 350+ pre-built connectors for syncing data from any source to warehouses, lakes, and AI pipelines. It handles incremental syncs, schema evolution, and change data capture with a connector builder for custom integrations. Used by DoorDash, Replit, and thousands of data teams. Over 15,000 GitHub stars and $150M+ in funding.

Context retrieval layer for AI agents and RAG

Airweave is an open-source context retrieval platform that connects AI agents and RAG systems to 50+ apps and databases through a unified search interface. It continuously syncs data from sources like Notion, Slack, GitHub, and databases, making it searchable through LLM-friendly APIs. Airweave includes Python and TypeScript SDKs, MCP support, and a CLI for managing data connections.

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.

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.

Database schema management for modern teams

Database schema management and migration tool by Ariga with a declarative schema-as-code approach. Features automatic migration planning, CI/CD integration, and drift detection to keep database schemas in sync across environments. Supports PostgreSQL, MySQL, MariaDB, and SQLite, making database changes as reviewable and version-controlled as application code.

Open-source SQL editor and DB manager

Beekeeper Studio is a modern, open-source SQL editor and cross-platform database GUI for MySQL, PostgreSQL, SQLite, SQL Server, MariaDB, CockroachDB, Amazon Redshift, Oracle, and LibSQL. Focuses on a clean interface, fast multi-tab editor, saved queries, data export, and schema browsing — a lightweight alternative to DBeaver or DataGrip for everyday database work on Windows, macOS, and Linux.

Database CI/CD and DevSecOps platform at scale

Bytebase is an open-source database DevSecOps platform that automates schema migrations, enforces SQL standards across 200+ lint rules, and provides fine-grained access control with dynamic data masking. Teams use it for GitOps-based database change management, SQL review, and compliance across PostgreSQL, MySQL, MongoDB, Snowflake, Oracle, SQL Server, and 20+ other databases. Available as self-hosted Docker or Kubernetes deployment, or as a managed cloud service.

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.

Real-time analytics OLAP database

ClickHouse is an open-source column-oriented database built for real-time analytical queries on massive datasets. Its columnar storage with advanced compression and vectorized query execution using SIMD instructions deliver exceptional performance for aggregations and scans. It handles billions of rows per second, supports SQL with analytical extensions, and scales horizontally for petabyte-scale data warehousing and real-time dashboards.

The reactive backend for modern apps

Reactive backend-as-a-service with real-time sync, TypeScript-native queries and mutations, automatic caching, and built-in file storage. No SQL required — define your backend logic in TypeScript and Convex handles the database, real-time subscriptions, and serverless functions. Ideal for apps that need instant data updates without complex WebSocket infrastructure.

Universal database tool

DBeaver is a free, open-source universal database GUI and SQL client supporting 100+ engines including PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, Cassandra, and Redis. Offers a consistent cross-platform interface for schema browsing, visual query building, SQL execution, data editing, ER diagrams, and data migration between heterogeneous databases, all in a single Java-based desktop app.

High-performance data engine for multimodal AI workloads

Daft is a high-performance distributed data engine designed specifically for AI and multimodal workloads. It processes structured data alongside images, audio, video, and embeddings natively, outperforming Spark and Polars on AI-specific data pipelines. Built in Rust with a Python API, Daft handles the data engineering challenges unique to machine learning workflows.

JetBrains database IDE

JetBrains' professional database IDE with intelligent SQL assistance, schema navigation, data editor, and admin tools for PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Redis, and more. Features context-aware completion, error detection, explain plan visualization, data export, and version control for schema changes. Part of JetBrains All Products pack or standalone. The premium choice for database development.

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.

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.

AI data runtime for multimodal datasets and vector search

Deep Lake is an open-source AI data runtime from Activeloop for storing, versioning, and querying multimodal data and embeddings. It fits teams building RAG, training, evaluation, or dataset-heavy agent workflows that need a bridge between vector search, structured metadata, and large image, text, audio, or video collections.