Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

PlyDB

plydb.com

  • Free plan
  • Windows
  • macOS
  • Linux
7.4 Club score Visit plydb.com

What PlyDB is

PlyDB is a free, open-source database gateway that lets AI agents query live sources with standard SQL. It runs locally and sends queries directly to connected data rather than moving or staging it. Agents connect through MCP or the CLI to discover schemas, execute SQL and analyze results; listed agents include Claude, ChatGPT, Gemini and Codex. One query can join PostgreSQL, CSV files and Google Sheets, alongside sources such as MySQL, SQLite, DuckDB, JSON, Parquet, Excel and Amazon S3. Persistent semantic overlays can retain context beyond a schema. PlyDB is read-only by default, with writes requiring explicit permission. Its FAQ says data stays in the user's infrastructure and only query results reach the AI agent. Installation covers macOS, Linux and Windows through single binaries with no runtime dependencies. The Apache 2.0 project is self-hosted; Apache Iceberg and Delta Lake support are planned.

Who it suits

PlyDB suits teams wanting local, self-hosted SQL access for AI agents across varied data sources. It is also aimed at DevOps, sales, revenue operations and executive insight workflows.

Good to know, and what to watch

  • Joins multiple sources in one SQL query
  • Runs locally without staging connected data
  • Read-only by default
  • Supports MCP and CLI agent access
  • Available for macOS, Linux and Windows
  • CLI use requires shell access
  • MCP requires restart after configuration changes
  • Apache Iceberg and Delta Lake are planned
  • No cloud-hosted option

The verdict

PlyDB gives AI agents a local SQL gateway with broad source support and default read-only behavior. Its self-hosted design keeps data in the user's infrastructure, while integration setup has operational requirements.

What the maker publishes

Access control
PlyDB is read-only by default, and its page says writes require explicit permission. source
Agent access
AI agents connect through MCP or the PlyDB CLI to discover schemas, run SQL queries, and analyze data. source
Agent integration
AI agents can connect to PlyDB through MCP or CLI, including Claude, ChatGPT, Gemini, and Codex. source
AI compatibility
The site lists Claude, ChatGPT, Gemini, and Codex among agents that work with PlyDB. source
Cross-source queries
PlyDB can federate sources so a single SQL query can join data such as a PostgreSQL table, CSV file, and Google Sheet. source
Cross-source SQL
PlyDB can join data from sources such as PostgreSQL, CSV files, and Google Sheets in one SQL query. source
Data movement
PlyDB executes queries directly against connected sources without moving or staging the data. source
Data movement
PlyDB executes queries directly against connected sources without copying or staging data. source
Google Sheets authentication
Google Sheets supports service account authentication for server-side use and browser OAuth for interactive querying. source
Installation
The site provides installation commands for macOS, Linux, and Windows and describes PlyDB as a single binary with no runtime dependencies. source
Installation platforms
The installation instructions provide quick-install commands for macOS, Linux, and Windows, and say pre-built binaries are available for all platforms. source
Integration limitation
The CLI requires shell access, while an MCP server must be restarted to pick up configuration changes. source
Intended users
The site presents use cases for DevOps incident response, sales and retention, revenue operations, and executive insights. source
License
PlyDB is open source under the Apache 2.0 license. source
License
PlyDB is open source under the Apache 2.0 license. source
Local operation
PlyDB runs locally and queries sources directly; the FAQ says data stays in the user's infrastructure and only query results go to the AI agent. source
Maker
The site footer identifies Paul Tzen. source
Planned sources
The site identifies Apache Iceberg and Delta Lake support as planned. source
Planned sources
Apache Iceberg and Delta Lake are listed as planned and are not yet supported. source
Privacy
PlyDB runs locally and queries sources directly; the FAQ says only query results are returned to the AI agent. source
Product
PlyDB is an open-source database gateway that lets AI agents query live data sources using standard SQL. source
Read-only behavior
PlyDB is read-only by default, and the site says agents cannot alter original data unless explicitly allowed. source
Semantic context
PlyDB discovers schemas and supports persistent semantic overlays that record information about data beyond its schema. source
Semantic context
PlyDB automatically scans sources for schemas, tables, columns, types, and database COMMENT metadata to provide agents with semantic context. source

Checked against the maker's pages on 8 Oct 2026.