Question 1

What is PGBox Cloud?

Accepted Answer

PGBox Cloud is a modern developer database platform that provides a schema-less, document-oriented developer experience (similar to MongoDB) directly powered by a production-ready PostgreSQL 16 engine. It combines document agility with 100% ACID compliance, native relational SQL JOINs, PostGIS 3.4, and Agent-Native Model Context Protocol (MCP) integrations.

Question 2

How does document storage work without sacrificing relational capabilities?

Accepted Answer

PGBox stores documents inside PostgreSQL 16 binary JSON (JSONB) columns with automated GIN indexes (GIN_JSONB_PATH_OPS). This delivers sub-millisecond filtering and containment queries while allowing developers to write SQL JOINs, define foreign keys, and perform transactional multi-table mutations across document collections.

Question 3

What are PGBox Type-Safe Action RPCs?

Accepted Answer

PGBox Actions are parameterized SQL business logic stored and executed within atomic PostgreSQL transactions. Through client libraries in TypeScript, Python, and Go, actions are invoked as native async methods (e.g. pgb.saveUser()) with full parameter type-safety and a safe dry_run simulation mode that previews results and rolls back before commit.

Question 4

How does PGBox integrate with AI Agents via Model Context Protocol (MCP)?

Accepted Answer

PGBox provides a native MCP server (@pgbox/mcp-server) compatible with Claude Code, Cursor, Windsurf, and Claude Desktop. AI models can introspect live schema definitions, execute registered actions, analyze slow query bottlenecks, and propose indexes without manual context pasting.

Question 5

What is the Query Performance Advisor in PGBox?

Accepted Answer

The Query Performance Advisor is a background service that continuously snapshots pg_stat_statements, detects slow queries and JSONB path filters, generates candidate B-tree and GIN indexes, validates them against the query planner using HypoPG cost estimation, and provides one-click non-blocking CREATE INDEX CONCURRENTLY execution.

Question 6

Is PGBox compatible with Prisma, Drizzle, and standard PostgreSQL clients?

Accepted Answer

Yes. PGBox is 100% standard PostgreSQL 16. Any ORM (Prisma, Drizzle, TypeORM, SQLAlchemy, GORM) and any client (psql, pgcli, psycopg, pgx) can connect directly via the provided Neon-style TLS connection strings.

Contact Sales & Inquiries