Welcome to pgEdge Documentation
Enterprise-grade PostgreSQL for distributed data and agentic AI.
pgEdge delivers hardened, production-grade PostgreSQL with a complete AI toolkit and a seamless path from a single database through highly available, globally distributed deployments — self-hosted, in your cloud, or fully managed.
Getting Started - Choose your Deployment
Key Components
pgEdge Postgres MCP Server
Give AI agents secure, structured access to PostgreSQL.
View Documentation →All Documentation
Deployment
- Control Plane Declarative API for deploying and managing PostgreSQL clusters on VMs and bare metal
- Enterprise Repository Hardened, tested PostgreSQL packages for enterprise Linux and Debian/Ubuntu
- Ansible Automated cluster deployment and configuration management with Ansible playbooks
- Containers Deploy pgEdge Enterprise Postgres on Kubernetes with Helm and CloudNativePG
- pgEdge Cloud Fully managed, globally distributed PostgreSQL as a service
AI Toolkit
- Overview Architecture guide covering agent access and RAG pipelines
- pgEdge Components
- MCP Server Connect LLMs and AI agents directly to PostgreSQL via the Model Context Protocol
- RAG Server High-performance retrieval-augmented generation API with hybrid vector and keyword search
- Docloader CLI tool for loading and chunking documents into PostgreSQL for AI applications
- Vectorizer Automatic document chunking and vector embedding generation inside PostgreSQL
- Community Components
- pgVector Open-source vector similarity search for PostgreSQL
Database
- PostgreSQL Reference documentation for PostgreSQL 16, 17, and 18
- pgEdge Extensions
- Spock Multi-master logical replication with conflict resolution for globally distributed clusters
- LOLOR Large object replication for handling BLOBs across distributed PostgreSQL nodes
- Snowflake Cluster-wide unique sequence generation without node coordination
- Vectorizer Automatic document chunking and vector embedding generation inside PostgreSQL
- Community Extensions
- pgVector Open-source vector similarity search for PostgreSQL
- PostGIS Spatial and geographic object support for PostgreSQL
- pgAudit Detailed session and object audit logging for PostgreSQL
Tools
- pgEdge Tools
- ACE Automated data integrity verification and repair across replicated cluster nodes
- Anonymizer Replace PII with realistic fake data for safe dev/test database copies
- Loadgen Generate realistic PostgreSQL workloads for performance testing and benchmarking
- Radar Agentless diagnostic data collection for PostgreSQL and system metrics
- Community Tools
- pgAdmin 4 Web-based administration and management tool for PostgreSQL
- PgBouncer Lightweight connection pooler for PostgreSQL
- pgBackRest Reliable PostgreSQL backup and restore
- PostgREST RESTful API server for any PostgreSQL database
- psycopg2 PostgreSQL database adapter for Python
Resources: GitHub • Website • Support • Discord
pgEdge is built by industry veterans with decades of PostgreSQL expertise. Founded in 2022 and headquartered in Northern Virginia, pgEdge serves prominent enterprises including Bertelsmann, Qube RT, European Parliament, and multiple U.S. government agencies.