PostgreBase — AI原生的无代码API开发工具
PostgreBase 是 AI 原生的无代码 API 开发平台，基于 PocketBase 重构。内置 MCP (Model Context Protocol) 服务器，让 AI 工具（Claude、Cursor、Windsurf）直接操作你的数据。支持 PostgreSQL、MySQL、SQLite 三种数据库，提供即时 REST API + 实时订阅 + Admin UI，5分钟上线你的后端服务。
Features
- Three Database Engines:
- PostgreSQL (default) — production-grade concurrency, clustering, and complex queries.
- MySQL — fully compatible via the
mysql://DSN prefix. - SQLite (pure Go, no CGO) — zero-dependency local development and testing via
sqlite://DSN or.dbfile path.
- Cluster-Ready Architecture: No reliance on local database files means multiple instances can run behind a load balancer with a shared PostgreSQL/MySQL backend.
- Hybrid Caching:
- Redis Cache (
--redisDsn) — distributed caching for cluster environments; SSE Realtime subscriptions synchronize across nodes via Redis Pub/Sub. - In-Memory Cache — automatic fallback to high-performance local memory caching when Redis is not configured.
- Redis Cache (
- MCP (Model Context Protocol) Server:
- JSON-RPC 2.0 protocol enabling AI tools (Claude Desktop, Cursor, Windsurf) to interact with your data.
- 8 built-in tools:
list_collections,get_collection,list_records,get_record,create_record,update_record,delete_record,search_records. - Resources:
postgrebase://collections,postgrebase://settings. - Three transport modes: SSE (HTTP), Streamable HTTP, and Stdio.
- MCP-specific API tokens with expiration support, manageable from the Admin UI.
- Zero External Dependencies for SQLite: Uses
modernc.org/sqlite(pure Go transpilation of SQLite), builds withCGO_ENABLED=0.
Quick Start
Prerequisites
- Go 1.26.2+
- PostgreSQL, MySQL, or nothing (SQLite works out of the box)
Build
git clone https://github.com/zhenruyan/postgrebase.git
cd postgrebase
go build -o pb ./build/
For static builds (no CGO):
CGO_ENABLED=0 go build -o pb ./build/
Run
SQLite (Local Development)
# Using sqlite:// prefix
./pb serve --dataDsn "sqlite://./pb_data/dev.db"
# Or just pass a .db file path
./pb serve --dataDsn "./pb_data/dev.db"
PostgreSQL (Recommended for Production)
./pb serve --dataDsn "postgresql://user:[email protected]:5432/dbname?sslmode=disable"
MySQL
./pb serve --dataDsn "mysql://user:password@tcp(127.0.0.1:3306)/dbname"
With Redis Cache
./pb serve --dataDsn "postgres://..." --redisDsn "redis://127.0.0.1:6379/0"
Docker
# Build the image
docker build -t postgrebase .
# Run with SQLite
docker run -p 8090:8090 -v pb_data:/pb/pb_data postgrebase serve --dataDsn "sqlite:///pb/pb_data/dev.db"
# Run with PostgreSQL
docker run -p 8090:8090 postgrebase serve --dataDsn "postgres://user:pass@host:5432/db?sslmode=disable"
# Run with Redis
docker run -p 8090:8090 postgrebase serve --dataDsn "postgres://..." --redisDsn "redis://host:6379/0"
On startup the server prints its endpoints:
├─ REST API: http://127.0.0.1:8090/api/
├─ MCP SSE: http://127.0.0.1:8090/api/mcp/sse
└─ Admin UI: http://127.0.0.1:8090/_/
Configuration Flags
DSN Formats
MCP (Model Context Protocol)
PostgreBase includes a built-in MCP server that allows AI tools to interact with your data via a standardized JSON-RPC 2.0 protocol.
Transport Modes
SSE (Server-Sent Events) — HTTP
Available when running ./pb serve. Connect to:
GET http://localhost:8090/api/mcp/sse # SSE event stream
POST http://localhost:8090/api/mcp/message # Send JSON-RPC requests
POST http://localhost:8090/api/mcp/stream # Streamable HTTP (single request/response)
Stdio — CLI
Run the MCP server as a standalone process communicating over stdin/stdout:
./pb mcp --dataDsn "sqlite://./dev.db" --mcp-token "YOUR_TOKEN"
# Or disable auth (NOT recommended for production)
./pb mcp --dataDsn "sqlite://./dev.db" --mcp-no-auth
Claude Desktop Configuration
{
"mcpServers": {
"postgrebase": {
"command": "/path/to/pb",
"args": ["mcp", "--dataDsn", "sqlite:///path/to/dev.db", "--mcp-no-auth"]
}
}
}
MCP Tokens
For production use, create dedicated MCP tokens (prefixed with mcp_) from the Admin UI under Settings → MCP Tokens. These tokens:
- Are separate from admin JWT tokens.
- Can be revoked individually.
- Support optional expiration dates.
- Are shown in full only once at creation time.
Available Tools
Available Resources
Development
Building Admin UI
If you modify the Admin UI, rebuild the embedded assets before compiling the Go binary:
cd ui
npm install
npm run build
cd ..
go build -o pb ./build/
Project Structure
postgrebase/
├── build/ # Main server entry point (main.go)
├── core/ # Application logic, DB connection, caching
├── daos/ # Data access objects (CRUD operations)
├── models/ # Data models and schema definitions
├── apis/ # HTTP API handlers (REST + MCP routes)
├── mcp/ # MCP server: protocol, tools, resources, transports
├── migrations/ # Database migrations (Postgres/MySQL/SQLite)
├── cmd/ # CLI commands (serve, mcp, admin)
├── dbx/ # Database query builder (fork of ozzo-dbx)
├── tools/ # Shared utilities (security, types, search, etc.)
├── ui/ # Admin UI (Svelte + Vite)
├── vendor/ # Go dependencies (preserved for offline builds)
└── postgrebase.go # Root package: CLI setup, config, bootstrap
Running Tests
go test ./tools/... ./models/... ./daos/...
Contributing
- Fork the repository.
- Create your feature branch (
git checkout -b feature/amazing-feature). - Commit your changes (
git commit -m 'Add some amazing feature'). - Push to the branch (
git push origin feature/amazing-feature). - Open a Pull Request.
Credits
This project is a fork of PocketBase. Special thanks to Gani Georgiev for the original amazing work.
License
Licensed under the MIT license.