{"version":1,"pages":[{"id":"2KpBAhMLCAzaSQd7nkv1","title":"pREST","pathname":"/","siteSpaceId":"sitesp_4wqUo","description":"pREST — open-source instant REST (Representational State Transfer) and Model Context Protocol (MCP) APIs for SQL databases. PostgreSQL-first, now multi-database."},{"id":"aNXtmnVd5839TBwK29hH","title":"Who uses pREST","pathname":"/readme/who-uses-prest","siteSpaceId":"sitesp_4wqUo","description":"Products and companies that use pREST","breadcrumbs":[{"label":"pREST"}]},{"id":"Uol2etI8RFU8lvjU4hHJ","title":"pREST Key Features","pathname":"/readme/prestd-key-features","siteSpaceId":"sitesp_4wqUo","description":"Key features of pREST — instant REST and MCP APIs for SQL databases, PostgreSQL-first native adapter, auth, ACL, multi-database, and plugins.","breadcrumbs":[{"label":"pREST"}]},{"id":"MzJ7qw1tpFpfKlvxaSX1","title":"Acronyms","pathname":"/readme/acronyms","siteSpaceId":"sitesp_4wqUo","description":"Acronyms used in pREST docs — REST, MCP, AI, SQL, HTTP, JWT, ACL, and related terms with short definitions and links to deeper guides.","breadcrumbs":[{"label":"pREST"}]},{"id":"EOOsEjnWlkdVZG9ighPO","title":"Contributing to pREST","pathname":"/readme/contributing-to-prestd","siteSpaceId":"sitesp_4wqUo","description":"contributions are welcome to help improve and grow the project","breadcrumbs":[{"label":"pREST"}]},{"id":"pQTCMTWmbUif1fvdVDQI","title":"pREST in the Media","pathname":"/readme/prest-in-the-media","siteSpaceId":"sitesp_4wqUo","description":"Press, tutorials, and community coverage of open-source pREST — videos, guides, comparisons, and integrations.","breadcrumbs":[{"label":"pREST"}]},{"id":"eKu81u3wdn4u60UKPP2S","title":"Code of Conduct","pathname":"/readme/code-of-conduct","siteSpaceId":"sitesp_4wqUo","description":"We are committed to creating a friendly and respectful environment for all participants","breadcrumbs":[{"label":"pREST"}]},{"id":"Wpu3XUlx9zio6QX7IpBS","title":"Code of Ethics","pathname":"/readme/code-of-ethics","siteSpaceId":"sitesp_4wqUo","description":"Collaboration, respect, and diversity are the cornerstones of pREST","breadcrumbs":[{"label":"pREST"}]},{"id":"h76GQiHniUCemwwihfUR","title":"Databases","pathname":"/databases","siteSpaceId":"sitesp_4wqUo","description":"Which SQL databases pREST supports today — Native PostgreSQL, certified Postgres-compatible engines, and the multi-database roadmap."},{"id":"wiznuMCVKapPsYx8y3iC","title":"Database roadmap","pathname":"/databases/roadmap","siteSpaceId":"sitesp_4wqUo","description":"pREST multi-database roadmap — PostgreSQL family first, then MySQL, SQLite, SQL Server; analytical databases on a separate read-only track.","breadcrumbs":[{"label":"Databases"}]},{"id":"l2BXtZ7rgnR991nhzOVu","title":"PostgreSQL","pathname":"/databases/postgresql","siteSpaceId":"sitesp_4wqUo","description":"Expose PostgreSQL as a REST and MCP API with pREST — native adapter, auto CRUD, auth, ACL, and read-only MCP at /_mcp.","breadcrumbs":[{"label":"Databases"}]},{"id":"6DWWE4iGb0qmTaH73RGN","title":"Amazon Aurora PostgreSQL","pathname":"/databases/aurora-postgresql","siteSpaceId":"sitesp_4wqUo","description":"Use Amazon Aurora PostgreSQL with pREST — same native PostgreSQL adapter, REST CRUD and MCP over the PostgreSQL wire protocol.","breadcrumbs":[{"label":"Databases"}]},{"id":"bYxkZ5Nq0FQIITbs6WBh","title":"CockroachDB","pathname":"/databases/cockroachdb","siteSpaceId":"sitesp_4wqUo","description":"CockroachDB REST and MCP via pREST — PostgreSQL wire-compatible, with a documented support matrix and known dialect differences.","breadcrumbs":[{"label":"Databases"}]},{"id":"wJJ2Th1hR7RHvrj9M8r7","title":"YugabyteDB","pathname":"/databases/yugabytedb","siteSpaceId":"sitesp_4wqUo","description":"YugabyteDB REST and MCP with pREST — connect via YSQL PostgreSQL wire protocol, with co-location and support matrix guidance.","breadcrumbs":[{"label":"Databases"}]},{"id":"4UMyOmZ6iw9BK7KAYOSi","title":"TimescaleDB","pathname":"/databases/timescaledb","siteSpaceId":"sitesp_4wqUo","description":"TimescaleDB with pREST — hypertables over the Postgres wire, auto-detect adapter in v2.3.0 (#999), _time_bucket, REST and MCP.","breadcrumbs":[{"label":"Databases"}]},{"id":"RZEWgYuw3azTbd9lTdWv","title":"Amazon Redshift","pathname":"/databases/amazon-redshift","siteSpaceId":"sitesp_4wqUo","description":"Amazon Redshift with pREST — PostgreSQL-based warehouse connectivity with important dialect differences and a cautious support matrix.","breadcrumbs":[{"label":"Databases"}]},{"id":"5VwPA1QQYtp4FkndySjU","title":"MySQL family (roadmap)","pathname":"/databases/mysql","siteSpaceId":"sitesp_4wqUo","description":"MySQL and MariaDB REST/MCP support for pREST is on the roadmap (Phase 2) — not available in current releases.","breadcrumbs":[{"label":"Databases"}]},{"id":"xpLD5XJEAGAvglSa9e5F","title":"SQLite (roadmap)","pathname":"/databases/sqlite","siteSpaceId":"sitesp_4wqUo","description":"SQLite REST and MCP support for pREST is on the roadmap (Phase 3) — turn a SQLite file into an API is planned, not shipped.","breadcrumbs":[{"label":"Databases"}]},{"id":"B19YzXBsacoafHAfX7TA","title":"SQL Server (roadmap)","pathname":"/databases/sql-server","siteSpaceId":"sitesp_4wqUo","description":"SQL Server and Azure SQL REST/MCP support for pREST is on the roadmap (Phase 4) — not available in current releases.","breadcrumbs":[{"label":"Databases"}]},{"id":"IzLM1qbE7gZMPI1HYMZ2","title":"Releases","pathname":"/releases","siteSpaceId":"sitesp_4wqUo","description":""},{"id":"mfiOiFjVUIYg3t8UXudV","title":"v2.3.0","pathname":"/releases/v2.3.0","siteSpaceId":"sitesp_4wqUo","description":"pREST v2.3.0 — critical _select SQL-injection fix (GHSA-qvx3-q8vx-9q3c), multi-adapter architecture with Postgres/TimescaleDB auto-detect, and JWKS hardening.","breadcrumbs":[{"label":"Releases"}]},{"id":"trsCzYtyLxgGfaILUinv","title":"v2.2.0","pathname":"/releases/v2.2.0","siteSpaceId":"sitesp_4wqUo","description":"pREST v2.2.0 — embedded Studio UI at /_studio/, database-backed custom queries, TimescaleDB E2E certification, and fully documented sample TOML.","breadcrumbs":[{"label":"Releases"}]},{"id":"lOIcLvuLitVFxu9I1NMx","title":"Changes since v2.1.0 (in v2.2.0)","pathname":"/releases/main-since-v2.1.0","siteSpaceId":"sitesp_4wqUo","description":"Changes since v2.1.0 included in v2.2.0 — Studio, database-backed queries, TimescaleDB E2E, sample TOML, and related packaging work.","breadcrumbs":[{"label":"Releases"}]},{"id":"KGAkCPrP1B4W0h37LH5V","title":"v2.1.0","pathname":"/releases/v2.1.0","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Releases"}]},{"id":"VfRZ0oGgzVScbGxz62Ij","title":"v2.0.0","pathname":"/releases/v2.0.0","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Releases"}]},{"id":"KyptocVkGUlUwGL1CPIz","title":"Changes since rc6 (in v2.0.0)","pathname":"/releases/main-since-rc6","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Releases"}]},{"id":"qJeUfFe7i9vWTHV10FYz","title":"v2.0.0-rc6","pathname":"/releases/v2.0.0-rc6","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Releases"}]},{"id":"vDd1F16HywpzdRabwh0v","title":"Get pREST","pathname":"/get-prest","siteSpaceId":"sitesp_4wqUo","description":"Download and run pREST — Docker, Homebrew, or Go — for instant REST and MCP APIs on SQL databases (PostgreSQL native today)."},{"id":"lU86DcZgAduXFCRSXyVP","title":"Development Guide","pathname":"/get-prest/development-guide","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get pREST"}]},{"id":"xXsbQT3NnqSataYMPu0S","title":"Start with Docker","pathname":"/get-prest/start-with-docker","siteSpaceId":"sitesp_4wqUo","description":"Run open-source pREST with Docker Compose — PostgreSQL plus prest image v2.2.0, auth migrate, JWT login, and optional MCP smoke check.","breadcrumbs":[{"label":"Get pREST"}]},{"id":"KRQRcT37b2b29mDcsSX8","title":"Start with Golang","pathname":"/get-prest/start-with-golang","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get pREST"}]},{"id":"TTWsx1bEcjst6yI4cUCD","title":"Start with Homebrew","pathname":"/get-prest/start-with-homebrew","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get pREST"}]},{"id":"sEO8ZenHfahBodWfhAdr","title":"Distribution channels","pathname":"/get-prest/distribution","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get pREST"}]},{"id":"y8T3i3PWehuXCoOPjI2x","title":"Get Started","pathname":"/get-started","siteSpaceId":"sitesp_4wqUo","description":"Configure pREST for production — REST (Representational State Transfer), auth, multi-database, and MCP (Model Context Protocol). PostgreSQL is native today."},{"id":"1LgVtrrI8Ob93KXuCPU9","title":"Configuring pREST","pathname":"/get-started/configuring-prest","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get Started"}]},{"id":"g0EZmVUAZhtFi68cRFqA","title":"pREST Studio","pathname":"/get-started/prest-studio","siteSpaceId":"sitesp_4wqUo","description":"pREST Studio — embedded admin UI at /_studio/ for catalog browsing, REST GET explorer, and MCP tools. Enabled by default in v2.2.0+.","breadcrumbs":[{"label":"Get Started"}]},{"id":"Xcz93FWz15FPR7rZ705C","title":"Multi-database","pathname":"/get-started/multi-database","siteSpaceId":"sitesp_4wqUo","description":"Run multiple SQL databases in one pREST instance — alias registry, Postgres and Timescale adapters, routing, pooling, and MCP.","breadcrumbs":[{"label":"Get Started"}]},{"id":"PKEd4iQwt763eODqupzq","title":"MCP over HTTP","pathname":"/get-started/mcp-over-http","siteSpaceId":"sitesp_4wqUo","description":"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.","breadcrumbs":[{"label":"Get Started"}]},{"id":"2SJdq15aZD7dByMTKHcv","title":"pREST MCP Adapter","pathname":"/get-started/prest-mcp-adapter","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get Started"}]},{"id":"Pu0iP4P8qHiELzPVOiKu","title":"Connect Cursor to pREST MCP","pathname":"/get-started/mcp-with-cursor","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get Started"}]},{"id":"mMSXZ8tO9HPgjY6RzJrQ","title":"Connect Claude Desktop to pREST MCP","pathname":"/get-started/mcp-with-claude-desktop","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get Started"}]},{"id":"nklQtyAiGxEvxTVvwuD5","title":"Upgrading to v2","pathname":"/get-started/upgrading-to-v2","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Get Started"}]},{"id":"zr2UVf0KGVCzpiTA3kfs","title":"CORS Support","pathname":"/get-started/cors-support","siteSpaceId":"sitesp_4wqUo","breadcrumbs":[{"label":"Get Started"}]},{"id":"OefHMh8Jj6jp8Ls7IHAr","title":"Cache","pathname":"/get-started/cache","siteSpaceId":"sitesp_4wqUo","breadcrumbs":[{"label":"Get Started"}]},{"id":"diDcsXNOfiMItKgYg5Wb","title":"Migrating","pathname":"/get-started/migrating","siteSpaceId":"sitesp_4wqUo","breadcrumbs":[{"label":"Get Started"}]},{"id":"QlcBlQPVKBGotE8mio7v","title":"Permissions","pathname":"/get-started/permissions","siteSpaceId":"sitesp_4wqUo","description":"How to manage tables read/writes","breadcrumbs":[{"label":"Get Started"}]},{"id":"Huaa95W3Z992UvcyEqX0","title":"AI and MCP","pathname":"/ai","siteSpaceId":"sitesp_4wqUo","description":""},{"id":"MYR3Scm4mzStWvM6PSBN","title":"MCP Overview","pathname":"/ai/mcp-overview","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"5AkOIqDNkxwwb2i4FqhW","title":"Install pREST MCP Adapter","pathname":"/ai/install-prest-mcp","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"rQLJ5Iidij0V5LkaHc4e","title":"Use with Cursor","pathname":"/ai/cursor","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"gBoo84txf51fBp53kid7","title":"pREST for Cursor plugin","pathname":"/ai/prest-cursor","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"3ZP8MyznpzJkoM1SOIgk","title":"pREST for OpenClaw plugin","pathname":"/ai/prest-openclaw","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"40uDh4ZMpHxanEAj5xyH","title":"Use with VS Code and Copilot","pathname":"/ai/vscode-copilot","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"7nXOfv8lM2cD3pmYlRZz","title":"Use with Claude Desktop","pathname":"/ai/claude-desktop","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"Uw1TE74FVjotbajGrSMZ","title":"Other AI tools","pathname":"/ai/other-clients","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"VFWcHcksSo4EpVF9r5Lo","title":"Read-only PostgreSQL for AI","pathname":"/ai/read-only-postgres","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"AI and MCP"}]},{"id":"rDvecpMO41gV7M1WjLp6","title":"Tutorials","pathname":"/postgres-to-ai-agent","siteSpaceId":"sitesp_4wqUo","description":""},{"id":"wJBY09cQoxvFdX3CTYuY","title":"Install adapter with Homebrew","pathname":"/postgres-to-ai-agent/install-prest-mcp-homebrew","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Tutorials"}]},{"id":"21pZy1KQ9MlLtlhs3Dgn","title":"API Reference","pathname":"/api-reference","siteSpaceId":"sitesp_4wqUo","description":"pREST API reference — REST (Representational State Transfer) HTTP endpoints that map to SQL on the native PostgreSQL adapter (and certified engines)."},{"id":"OCuOecdur38PCZEvV9ir","title":"Custom Queries","pathname":"/api-reference/custom-queries","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"API Reference"}]},{"id":"lY6l2iciyHLCdHfOLlN0","title":"Auth","pathname":"/api-reference/auth","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"API Reference"}]},{"id":"NB47ESUavbtfBNmeQZUg","title":"Parameters","pathname":"/api-reference/parameters","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"API Reference"}]},{"id":"TxBEeAPU8VrWYgMBiUnn","title":"Advanced Queries","pathname":"/api-reference/advanced-queries","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"API Reference"}]},{"id":"u3ZW6C2jjag1fMkiI54o","title":"Deployment","pathname":"/deployment","siteSpaceId":"sitesp_4wqUo","description":""},{"id":"M93FF96EozL8GeVRtxvW","title":"Deploying with Docker","pathname":"/deployment/deploying-with-docker","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Deployment"}]},{"id":"XwT5aXY6CI4zcQJLFpQj","title":"Deploy in Heroku","pathname":"/deployment/deploy-in-heroku","siteSpaceId":"sitesp_4wqUo","breadcrumbs":[{"label":"Deployment"}]},{"id":"4OT8d5WeSAlHSlcL0nEQ","title":"Plugins","pathname":"/plugins","siteSpaceId":"sitesp_4wqUo","description":""},{"id":"ty934DLwqvL9RyRnVeMP","title":"Middleware Plugin","pathname":"/plugins/middleware-plugin","siteSpaceId":"sitesp_4wqUo","description":"Bring your own middlewares to pREST","breadcrumbs":[{"label":"Plugins"}]},{"id":"zUiE2tRN8ScFVEsyc20U","title":"Endpoint Plugin","pathname":"/plugins/endpoint-plugin","siteSpaceId":"sitesp_4wqUo","description":"Bring your own custom endpoint to pREST","breadcrumbs":[{"label":"Plugins"}]},{"id":"ScsKhl3TB0Qf3t5EpAxY","title":"Integrations","pathname":"/integrations","siteSpaceId":"sitesp_4wqUo","description":"Deep how-tos for Postgres-compatible engines. For support labels and the multi-database roadmap, start at Databases."},{"id":"ndsplowJOlBVhNF4obgu","title":"Amazon Redshift","pathname":"/integrations/amazon-redshift","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"PcFQzjxfSw43EytmsYCE","title":"TimescaleDB","pathname":"/integrations/timescaledb","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Integrations"}]},{"id":"8QrKstxTWfZrmugFJp0M","title":"YugabyteDB","pathname":"/integrations/yugabytedb","siteSpaceId":"sitesp_4wqUo","description":"","breadcrumbs":[{"label":"Integrations"}]}]}