PlyDB
plydb.com
- Free plan
- Windows
- macOS
- Linux
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.