# pREST

## pREST

- [pREST](https://docs.prestd.com/readme.md): pREST — open-source instant REST (Representational State Transfer) and Model Context Protocol (MCP) APIs for SQL databases. PostgreSQL-first, now multi-database.
- [Who uses pREST](https://docs.prestd.com/readme/who-uses-prest.md): Products and companies that use pREST
- [pREST Key Features](https://docs.prestd.com/readme/prestd-key-features.md): Key features of pREST — instant REST and MCP APIs for SQL databases, PostgreSQL-first native adapter, auth, ACL, multi-database, and plugins.
- [Acronyms](https://docs.prestd.com/readme/acronyms.md): Acronyms used in pREST docs — REST, MCP, AI, SQL, HTTP, JWT, ACL, and related terms with short definitions and links to deeper guides.
- [Contributing to pREST](https://docs.prestd.com/readme/contributing-to-prestd.md): contributions are welcome to help improve and grow the project
- [pREST in the Media](https://docs.prestd.com/readme/prest-in-the-media.md): Press, tutorials, and community coverage of open-source pREST — videos, guides, comparisons, and integrations.
- [Code of Conduct](https://docs.prestd.com/readme/code-of-conduct.md): We are committed to creating a friendly and respectful environment for all participants
- [Code of Ethics](https://docs.prestd.com/readme/code-of-ethics.md): Collaboration, respect, and diversity are the cornerstones of pREST
- [Databases](https://docs.prestd.com/databases.md): Which SQL databases pREST supports today — Native PostgreSQL, certified Postgres-compatible engines, and the multi-database roadmap.
- [Database roadmap](https://docs.prestd.com/databases/roadmap.md): pREST multi-database roadmap — PostgreSQL family first, then MySQL, SQLite, SQL Server; analytical databases on a separate read-only track.
- [PostgreSQL](https://docs.prestd.com/databases/postgresql.md): Expose PostgreSQL as a REST and MCP API with pREST — native adapter, auto CRUD, auth, ACL, and read-only MCP at /\_mcp.
- [Amazon Aurora PostgreSQL](https://docs.prestd.com/databases/aurora-postgresql.md): Use Amazon Aurora PostgreSQL with pREST — same native PostgreSQL adapter, REST CRUD and MCP over the PostgreSQL wire protocol.
- [CockroachDB](https://docs.prestd.com/databases/cockroachdb.md): CockroachDB REST and MCP via pREST — PostgreSQL wire-compatible, with a documented support matrix and known dialect differences.
- [YugabyteDB](https://docs.prestd.com/databases/yugabytedb.md): YugabyteDB REST and MCP with pREST — connect via YSQL PostgreSQL wire protocol, with co-location and support matrix guidance.
- [TimescaleDB](https://docs.prestd.com/databases/timescaledb.md): TimescaleDB with pREST — hypertables over the Postgres wire, auto-detect adapter in v2.3.0 (#999), \_time\_bucket, REST and MCP.
- [Amazon Redshift](https://docs.prestd.com/databases/amazon-redshift.md): Amazon Redshift with pREST — PostgreSQL-based warehouse connectivity with important dialect differences and a cautious support matrix.
- [MySQL family (roadmap)](https://docs.prestd.com/databases/mysql.md): MySQL and MariaDB REST/MCP support for pREST is on the roadmap (Phase 2) — not available in current releases.
- [SQLite (roadmap)](https://docs.prestd.com/databases/sqlite.md): SQLite REST and MCP support for pREST is on the roadmap (Phase 3) — turn a SQLite file into an API is planned, not shipped.
- [SQL Server (roadmap)](https://docs.prestd.com/databases/sql-server.md): SQL Server and Azure SQL REST/MCP support for pREST is on the roadmap (Phase 4) — not available in current releases.
- [Releases](https://docs.prestd.com/releases.md)
- [v2.3.0](https://docs.prestd.com/releases/v2.3.0.md): pREST v2.3.0 — critical \_select SQL-injection fix (GHSA-qvx3-q8vx-9q3c), multi-adapter architecture with Postgres/TimescaleDB auto-detect, and JWKS hardening.
- [v2.2.0](https://docs.prestd.com/releases/v2.2.0.md): pREST v2.2.0 — embedded Studio UI at /\_studio/, database-backed custom queries, TimescaleDB E2E certification, and fully documented sample TOML.
- [Changes since v2.1.0 (in v2.2.0)](https://docs.prestd.com/releases/main-since-v2.1.0.md): Changes since v2.1.0 included in v2.2.0 — Studio, database-backed queries, TimescaleDB E2E, sample TOML, and related packaging work.
- [v2.1.0](https://docs.prestd.com/releases/v2.1.0.md)
- [v2.0.0](https://docs.prestd.com/releases/v2.0.0.md)
- [Changes since rc6 (in v2.0.0)](https://docs.prestd.com/releases/main-since-rc6.md)
- [v2.0.0-rc6](https://docs.prestd.com/releases/v2.0.0-rc6.md)
- [Get pREST](https://docs.prestd.com/get-prest.md): Download and run pREST — Docker, Homebrew, or Go — for instant REST and MCP APIs on SQL databases (PostgreSQL native today).
- [Development Guide](https://docs.prestd.com/get-prest/development-guide.md)
- [Start with Docker](https://docs.prestd.com/get-prest/start-with-docker.md): Run open-source pREST with Docker Compose — PostgreSQL plus prest image v2.2.0, auth migrate, JWT login, and optional MCP smoke check.
- [Start with Golang](https://docs.prestd.com/get-prest/start-with-golang.md)
- [Start with Homebrew](https://docs.prestd.com/get-prest/start-with-homebrew.md)
- [Distribution channels](https://docs.prestd.com/get-prest/distribution.md)
- [Get Started](https://docs.prestd.com/get-started.md): Configure pREST for production — REST (Representational State Transfer), auth, multi-database, and MCP (Model Context Protocol). PostgreSQL is native today.
- [Configuring pREST](https://docs.prestd.com/get-started/configuring-prest.md)
- [pREST Studio](https://docs.prestd.com/get-started/prest-studio.md): pREST Studio — embedded admin UI at /\_studio/ for catalog browsing, REST GET explorer, and MCP tools. Enabled by default in v2.2.0+.
- [Multi-database](https://docs.prestd.com/get-started/multi-database.md): Run multiple SQL databases in one pREST instance — alias registry, Postgres and Timescale adapters, routing, pooling, and MCP.
- [MCP over HTTP](https://docs.prestd.com/get-started/mcp-over-http.md): pREST MCP over HTTP — Model Context Protocol (MCP) read-only tools at /\_mcp for AI agents to discover schemas and query SQL tables on the same server as REST.
- [pREST MCP Adapter](https://docs.prestd.com/get-started/prest-mcp-adapter.md)
- [Connect Cursor to pREST MCP](https://docs.prestd.com/get-started/mcp-with-cursor.md)
- [Connect Claude Desktop to pREST MCP](https://docs.prestd.com/get-started/mcp-with-claude-desktop.md)
- [Upgrading to v2](https://docs.prestd.com/get-started/upgrading-to-v2.md)
- [CORS Support](https://docs.prestd.com/get-started/cors-support.md)
- [Cache](https://docs.prestd.com/get-started/cache.md)
- [Migrating](https://docs.prestd.com/get-started/migrating.md)
- [Permissions](https://docs.prestd.com/get-started/permissions.md): How to manage tables read/writes
- [AI and MCP](https://docs.prestd.com/ai.md)
- [MCP Overview](https://docs.prestd.com/ai/mcp-overview.md)
- [Install pREST MCP Adapter](https://docs.prestd.com/ai/install-prest-mcp.md)
- [Use with Cursor](https://docs.prestd.com/ai/cursor.md)
- [pREST for Cursor plugin](https://docs.prestd.com/ai/prest-cursor.md)
- [pREST for OpenClaw plugin](https://docs.prestd.com/ai/prest-openclaw.md)
- [Use with VS Code and Copilot](https://docs.prestd.com/ai/vscode-copilot.md)
- [Use with Claude Desktop](https://docs.prestd.com/ai/claude-desktop.md)
- [Other AI tools](https://docs.prestd.com/ai/other-clients.md)
- [Read-only PostgreSQL for AI](https://docs.prestd.com/ai/read-only-postgres.md)
- [Tutorials](https://docs.prestd.com/postgres-to-ai-agent.md)
- [Install adapter with Homebrew](https://docs.prestd.com/postgres-to-ai-agent/install-prest-mcp-homebrew.md)
- [API Reference](https://docs.prestd.com/api-reference.md): pREST API reference — REST (Representational State Transfer) HTTP endpoints that map to SQL on the native PostgreSQL adapter (and certified engines).
- [Custom Queries](https://docs.prestd.com/api-reference/custom-queries.md)
- [Auth](https://docs.prestd.com/api-reference/auth.md)
- [Parameters](https://docs.prestd.com/api-reference/parameters.md)
- [Advanced Queries](https://docs.prestd.com/api-reference/advanced-queries.md)
- [Deployment](https://docs.prestd.com/deployment.md)
- [Deploying with Docker](https://docs.prestd.com/deployment/deploying-with-docker.md)
- [Deploy in Heroku](https://docs.prestd.com/deployment/deploy-in-heroku.md)
- [Plugins](https://docs.prestd.com/plugins.md)
- [Middleware Plugin](https://docs.prestd.com/plugins/middleware-plugin.md): Bring your own middlewares to pREST
- [Endpoint Plugin](https://docs.prestd.com/plugins/endpoint-plugin.md): Bring your own custom endpoint to pREST
- [Integrations](https://docs.prestd.com/integrations.md): Deep how-tos for Postgres-compatible engines. For support labels and the multi-database roadmap, start at Databases.
- [Amazon Redshift](https://docs.prestd.com/integrations/amazon-redshift.md)
- [TimescaleDB](https://docs.prestd.com/integrations/timescaledb.md)
- [YugabyteDB](https://docs.prestd.com/integrations/yugabytedb.md)