Databases & ORMs

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.

Postgres sync engine for local-first and real-time applications

ElectricSQL is a sync engine that keeps local application state synchronized with PostgreSQL in real-time. It enables local-first architectures where apps work offline with instant responsiveness, syncing data bidirectionally when connectivity is available. Supports partial replication with shape-based subscriptions to sync only relevant data subsets to each client.

Graph-relational database with EdgeQL query language, formerly EdgeDB

Gel (formerly EdgeDB) is a graph-relational database that combines the relational model with graph database traversal capabilities through its EdgeQL query language. Built on PostgreSQL, it eliminates the object-relational impedance mismatch with a type system that maps directly to application data models. Features built-in migrations, authentication, and an interactive web UI.

MCP server for secure database tooling with AI agents

Google GenAI Toolbox is an open-source MCP server from Google that specializes in easy, fast, and secure database tools for AI agents. It provides structured database access through the Model Context Protocol, enabling agents to query, inspect schemas, and manage data across supported databases with built-in security controls.

Build real-time temporal knowledge graphs for AI agents

Graphiti is an open-source Python framework by Zep for building temporally-aware knowledge graphs for AI agents. It continuously integrates conversations, business data, and external information into queryable graphs with bi-temporal tracking. The hybrid retrieval combines semantic search, BM25 keywords, and graph traversal for sub-300ms queries without LLM calls at retrieval time.

Constrained generation that guarantees valid LLM outputs every time

Guidance is Microsoft's structured generation library that enforces output constraints directly within LLM decoding. It supports JSON schemas, regex patterns, grammars, and interleaved generation-and-control flow to guarantee valid outputs from any compatible model. Works with local models via llama.cpp, Transformers, and remote APIs including OpenAI and Anthropic. Eliminates retry loops and post-processing for structured data extraction.

Instant GraphQL and REST APIs on any database

Hasura auto-generates real-time GraphQL and REST APIs directly from your database schema—PostgreSQL, MySQL, SQL Server, MongoDB, and more. It provides fine-grained row-level and column-level access control, event triggers on database changes, remote schema stitching, and real-time subscriptions out of the box. Available as a managed cloud service or self-hosted, Hasura eliminates weeks of boilerplate API development while maintaining full control over authorization logic.

SQL query builder for Node.js

Flexible SQL query builder for Node.js supporting PostgreSQL, MySQL, SQLite, Oracle, and MSSQL. Chainable API for constructing queries with parameterized bindings. Features schema builder, migration system, seed files, transaction support, and connection pooling. Foundation for ORMs like Bookshelf.js and Objection.js. One of the most established query builders in the Node.js ecosystem.

Type-safe SQL query builder for TS

Type-safe SQL query builder for TypeScript that provides auto-completion and compile-time type checking without the abstraction overhead of a traditional ORM. Write queries that map directly to SQL while getting full TypeScript inference from your database schema. Supports PostgreSQL, MySQL, and SQLite with migrations, transactions, and raw SQL escape hatches. Lightweight with zero dependencies. Ideal for developers who want SQL control with TypeScript safety. Growing Knex.js alternative.

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-source MCP server for database access

MCP Toolbox for Databases is an open-source MCP server by Google that connects AI agents to databases through a managed control plane. It handles connection pooling, authentication, and tool distribution, letting developers integrate database tools in under 10 lines of code. Supports PostgreSQL, MySQL, BigQuery, AlloyDB, Snowflake, MongoDB, Redis, ClickHouse, Neo4j, and more with ready-to-use toolsets for Claude Code, Gemini CLI, and other MCP clients.

Embedding-first search and discovery engine for AI-powered product experiences.

Marqo is an open-source tensor search engine that combines embedding generation and vector search in a single API, removing the need to manage separate embedding pipelines and vector databases. Built for product discovery and multi-modal search, it lets teams index text, images, and structured data together, returning ranked results based on semantic similarity rather than keyword overlap.

Lightning-fast, open-source search engine — a developer-friendly Algolia alternative.

Meilisearch is an open-source, lightning-fast search engine written in Rust. Designed as a developer-friendly alternative to Algolia with typo tolerance, faceted search, filtering, and sorting out of the box. Sub-50ms response times. Easy to deploy and configure with a RESTful API.

SQL-native memory infrastructure for AI agents and applications

Memori is an AI memory engine that provides persistent, queryable memory for agents and applications using SQL-native storage. It stores structured memories with semantic search, temporal awareness, and relationship tracking, enabling AI systems to remember user preferences, past interactions, and contextual facts across sessions. With 12,900 GitHub stars, it offers a database-native approach to the agent memory problem.

Self-hostable Airtable alternative with database power

NocoDB is a free, self-hostable source-available platform that turns any database into a smart spreadsheet interface. It offers grid, gallery, form, Kanban, and calendar views with support for rich field types including links, lookups, rollups, and formulas. NocoDB provides role-based access control, REST APIs, workflow automation, and integrations with services like Slack and Discord — making it a powerful Airtable alternative for teams who want full data ownership.

Full-text and vector search engine in under 2KB

Orama is a complete search engine and RAG pipeline that runs in browsers, servers, and edge environments in under 2KB. It provides full-text search, vector search, and hybrid search with built-in faceting, filters, geo-search, and typo tolerance. Orama requires no external dependencies and works entirely client-side for instant search experiences, or server-side with Node.js and Deno for larger datasets.

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.

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.

Elasticsearch-quality full-text and hybrid search inside Postgres

ParadeDB brings Elasticsearch-quality full-text search, BM25 ranking, and hybrid vector-keyword search directly into PostgreSQL as native extensions. Backed by a 12 million dollar Series A with over 500,000 Docker deployments, it eliminates the overhead of running separate search infrastructure. Teams get powerful search within their existing Postgres stack without managing additional clusters.

Declarative multimodal AI data infrastructure

Pixeltable is a declarative data infrastructure for multimodal AI that stores video, audio, images, and documents as first-class column types. Define Python computed columns for inference and transformations, and Pixeltable auto-orchestrates execution with incremental updates. Built-in vector search eliminates the need for separate vector databases while supporting RAG and semantic search workflows.

Modern PostgreSQL client for Mac

Native macOS client for PostgreSQL with a clean, intuitive interface designed for simplicity. Features a visual table editor for inline data editing, SQL query editor with syntax highlighting, table structure inspector, favorites for saved queries, and SSH tunnel support. Known for its polished Apple-native UI and ease of use compared to heavier tools. Ideal for developers and designers who need quick PostgreSQL access without enterprise complexity.

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.

In-memory data store

In-memory data structure store used as database, cache, message broker, and streaming engine. Supports strings, hashes, lists, sets, sorted sets, streams, geospatial indexes, and HyperLogLog. Features pub/sub messaging, Lua scripting, transactions, persistence (RDB/AOF), replication, and Redis Cluster for horizontal scaling. Redis Stack adds JSON, search, time series, and graph capabilities. Sub-millisecond latency. Available as open-source or managed (Redis Cloud, AWS ElastiCache).

High-performance S3-compatible object storage built in Rust

RustFS is an open-source distributed object storage system built entirely in Rust, offering 2.3x faster performance than MinIO for small object payloads. It provides full S3 API compatibility, enabling seamless migration from MinIO, Ceph, and AWS S3 with existing SDKs and CLI tools. Released under Apache 2.0 license, it avoids MinIO's restrictive AGPL terms. Features include distributed architecture, erasure coding, WORM compliance, encryption via RustyVault, and a web management console.

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-native state store with hybrid vector and full-text search

SeekDB is an open-source AI-native state store from the OceanBase ecosystem that combines MySQL-compatible data access with hybrid vector and full-text retrieval. It targets agent and AI application teams that need embedded or server deployment, copy-on-write style sandboxes, and searchable state without gluing together several separate storage layers.

Promise-based Node.js ORM

Mature, promise-based ORM for Node.js supporting PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server. Features model definitions with validations, eager/lazy loading, transactions, migrations, raw queries, and lifecycle hooks. Supports soft deletes, scopes, and virtual fields. One of the oldest and most battle-tested Node.js ORMs, widely used in enterprise apps though increasingly succeeded by Prisma and Drizzle in new projects.

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.

Google Zanzibar-inspired authorization database

SpiceDB is an open-source authorization database inspired by Google's Zanzibar system, providing relationship-based access control (ReBAC) at scale. It defines permissions through a schema language that models relationships between users, resources, and roles, then evaluates authorization checks in single-digit milliseconds. Used by companies like Netflix and GitHub, SpiceDB handles millions of permission checks per second.

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.

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.

Modern database management GUI

Native database management GUI for macOS, Windows, and Linux that provides a fast, clean interface for working with PostgreSQL, MySQL, SQLite, SQL Server, Redis, CockroachDB, and more. Features an intuitive query editor with auto-completion, visual table editor for inline data editing, import/export in multiple formats, SSH tunnel support, and connection management. Known for its speed and polished UI compared to heavier tools like DBeaver. Popular among Mac developers.

Enterprise feature platform for real-time ML

Tecton is an enterprise feature platform for building and serving ML features at scale. Created by the team behind Feast, it provides managed feature engineering, real-time feature computation from streaming data, feature monitoring, and a unified feature store with offline/online consistency. Used by production ML teams to eliminate training-serving skew and accelerate model deployment cycles.

Managed Postgres platform with 200+ extensions as pre-built stacks

Tembo is a managed PostgreSQL platform that packages 200+ Postgres extensions into purpose-built stacks for specific workloads. Stacks include OLAP analytics, vector search, message queues, geospatial, and machine learning, turning PostgreSQL into a specialized database for each use case. Eliminates the need for separate Redis, Elasticsearch, or Kafka instances alongside Postgres.

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.

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.

SQLite for production

Edge-hosted distributed database built on libSQL (an open-source fork of SQLite) designed for low-latency data access worldwide. Features multi-region replication, embedded replicas that sync to your application server for microsecond reads, database branching for development workflows, and point-in-time recovery. Ideal for edge computing, serverless functions, and mobile apps. Compatible with SQLite ecosystem tooling. Generous free tier with 9GB storage and 500 databases.

ORM for TypeScript and JavaScript

Full-featured ORM for TypeScript and JavaScript supporting Active Record and Data Mapper patterns. Works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, and MongoDB. Features decorator-based entity definitions, migrations, relations (one-to-one, many-to-many), lazy/eager loading, query builder, transactions, and caching. Supports both Node.js and browser runtimes. 34K+ GitHub stars. Mature but losing mindshare to Prisma and Drizzle for new TypeScript projects.

Open-source search engine — fast, typo-tolerant, easy to use.

Typesense is an open-source, typo-tolerant search engine optimized for instant search experiences. Written in C++ for maximum performance. Features built-in vector search for semantic/hybrid queries, geo-search, faceting, and curation. Popular for e-commerce search, documentation sites, and SaaS applications.

Fast embeddable vector search engine

USearch is a high-performance vector search engine implementing HNSW algorithms for approximate nearest neighbor queries across C++, Python, JavaScript, Rust, Java, Go, and more. It supports user-defined distance metrics, memory-mapped persistence for datasets larger than RAM, and filtered search with predicates. Used by YugabyteDB and ScyllaDB as their production vector indexing backend.

Serverless Redis, Kafka, and vector database

Upstash provides serverless Redis, Kafka, and vector database services with per-request pricing and zero operational overhead. Redis supports global replication for edge computing. Kafka offers pay-per-message event streaming. QStash provides HTTP-based message queues for serverless. Features REST APIs alongside native protocols, ideal for edge and serverless deployments. Integrates with Vercel, Cloudflare Workers, and AWS Lambda natively.

Cloud-native distributed vector search engine built for Kubernetes with automatic indexing and horizontal scaling.

Vald is a highly scalable distributed approximate nearest neighbor (ANN) vector search engine designed for cloud-native, Kubernetes-based architectures. Maintained by LY Corporation and listed in the CNCF Landscape, it uses the NGT algorithm (developed at Yahoo Japan), supports automatic incremental index backup, and handles billion-scale datasets across loosely coupled microservice components that scale horizontally via Helm.

One vector-search extension across PostgreSQL, DuckDB and SQLite

MIT-licensed vector-search extension for PostgreSQL, DuckDB and SQLite that shares one graph-index core with PQ/RaBitQ quantization, persistent indexes and metadata filtering; SQLite packages cover Linux, macOS, iOS, Android and WASM, so it runs inside existing databases instead of as a separate vector service.

Enterprise RAG framework by Tencent

WeKnora is a Tencent-developed LLM-powered knowledge management and Q&A framework for enterprise document understanding and semantic retrieval. Supports 10+ document formats including PDF, Word, Excel, and images with seamless IM platform integration for WeCom, Feishu, Slack, and Telegram. Offers Quick Q&A mode using RAG pipelines and Intelligent Reasoning mode with ReACT agents for complex multi-step reasoning tasks across organizational knowledge bases.

Serverless database with search and AI built-in

Serverless database platform that combines Postgres, full-text search, analytics, and AI features in a single service. Built-in vector search for AI applications, branching for safe schema changes, and a spreadsheet-like UI for data exploration. Designed for developers who want powerful database capabilities without managing separate services for search, analytics, and embeddings.

In-process vector database — the SQLite of vector DBs

Zvec is an open-source in-process vector database from Alibaba designed as the SQLite of vector search. It runs as an embedded library directly inside applications without requiring external servers, delivering 8,000+ QPS with high recall rates. Zvec supports dense and sparse embeddings, multi-vector queries, and combined semantic plus structured filtering. Built on Alibaba's proven Proxima engine, it provides a lightweight alternative to server-based vector databases for local AI workflows.

SQL-based data transformation framework

dbt (data build tool) is an open-source SQL transformation framework with 10K+ GitHub stars that lets analytics engineers transform data in their warehouse using select statements. Brings software engineering practices to data — version control, testing, documentation, and CI/CD for SQL. Supports Snowflake, BigQuery, Redshift, Databricks, PostgreSQL, and more. Features Jinja templating, incremental models, snapshots, and a package hub of reusable transformations.

Python library for declarative data loading that LLMs can generate

dlt (data load tool) is a Python library for building data pipelines with declarative, schema-aware loading that is simple enough for LLMs to generate correctly. It extracts data from APIs, databases, and files, normalizes nested structures, handles schema evolution, and loads into warehouses and lakes. Supports 30+ destinations including BigQuery, Snowflake, DuckDB, and PostgreSQL. Over 5,200 GitHub stars.