AI Database Tools tagged open-source

Chroma is an open-source (Apache 2.0) embedding database designed for developer simplicity and rapid prototyping of AI applications. Core library is free; Chroma Cloud in preview with pricing TBD.

Datafold provides data quality testing with automated diff capabilities for validating data migrations, transformations, and pipeline changes. Data Diff (open-source) compares tables across databases highlighting row-level differences.

DBeaver is the most popular open-source database tool with Community Edition (free, Apache 2.0) supporting 80+ databases and Enterprise Edition ($250/year) adding AI features and advanced capabilities.

DBHub (by Bytebase) is a free, open-source (MIT license) universal database gateway implementing Model Context Protocol (MCP) for AI assistant integration.

dbt (data build tool) has become the standard for analytics engineering, providing SQL-based data transformation with software engineering practices. dbt Core is free and open-source (Apache 2.0).

Flyway is the leading database migration tool providing version control for database schemas through SQL or Java migrations. Community edition free and open-source. Teams at $497/year (10 users) adds undo, dry run, and comparison features.

LanceDB is an open-source (Apache 2.0) serverless vector database using the Lance columnar format, designed for zero-copy integration with ML frameworks. Free and self-hosted; LanceDB Cloud in development.

LangChain provides SQLDatabaseToolkit and SQL Agent capabilities for building text-to-SQL applications with LLM orchestration. Open-source (MIT license) Python and JavaScript libraries.

libSQL is an open-source fork of SQLite adding features including native vector search, designed for edge and embedded deployments. Free and open-source (MIT).

Liquibase provides database schema change management with changelog-based tracking and rollback capabilities. Open Source free (Apache 2.0); Pro at $3,600+/year adds quality checks, secrets management, and parallel changes.

LlamaIndex provides NLSQLTableQueryEngine and SQL-focused components for building text-to-SQL applications with emphasis on data retrieval quality. Open-source (MIT license) Python library.

MyScaleDB is an open-source SQL-native vector database achieving 98% accuracy at 100+ QPS, built on ClickHouse for analytical performance. Free Community tier available; pricing for managed service varies.

pgAdmin is the official, free, open-source administration and development platform for PostgreSQL. pgAdmin 4 (current version) provides both desktop application and web-based server deployment modes.

pgvector is a PostgreSQL extension enabling vector similarity search directly within the database, eliminating need for separate vector database infrastructure. Free and open-source (PostgreSQL license).

Soda provides data quality monitoring with natural language check definitions and automated anomaly detection. Soda Core (open-source, Apache 2.0) enables local data quality checks.

sqlite-vec is a SQLite extension providing vector search capabilities for embedded and local applications. Free and open-source (MIT).