Is PgArachne right for you?
PgArachne™ is a production-grade backend gateway — from a solo MVP to a high-traffic production system. Define a SQL function, and your API endpoint is ready. No boilerplate, no extra services.
🚀 Zero Boilerplate
Stop writing repetitive CRUD controllers. Define a SQL function and your API endpoint is ready instantly. Your database is your backend — PgArachne just exposes it securely.
🏢 Production Ready
Designed to handle over 90 % of standard backend tasks (CRUD, validation, auth). With connection pooling, graceful shutdowns, and Prometheus metrics, it powers production systems reliably.
🧠 Native MCP & AI Support
PgArachne exposes a native Model Context Protocol (MCP) endpoint, so AI clients like Claude Desktop or Cursor can discover and call your PostgreSQL functions as tools — with zero extra code. The API is also self-documenting via SQL comments for LLM consumption.
⚡ Real-time Notifications (SSE)
Stream real-time events over standard HTTP with built-in browser support. Subscribe to PostgreSQL NOTIFY channels directly from the client. Great for dashboards and live updates without WebSockets.
🔒 Database-Native Security
No separate user tables. Authentication uses real PostgreSQL roles and JWT. Every request runs as the authenticated user via SET LOCAL ROLE, so Row-Level Security (RLS) works automatically.
🏛️ Design Decisions
Why JSON-RPC? Why Go? Why SSE? Why MCP as a translation layer? Read our Detailed Architectural Decisions to understand the engine under the hood.