Postgres with Builtin File Systems
a day ago
- #AI agents
- #PostgreSQL
- #serverless
- Create, manage, and query serverless PostgreSQL databases from the terminal with db9.
- Supports branching, migrations, observability, and type generation.
- Combines PostgreSQL with a cloud filesystem for AI agents, offering SQL for power and file operations for simplicity.
- Agents can autonomously install, authenticate, and use db9 for personal assistants, customer copilots, and more.
- Structured data is stored in PostgreSQL, while raw context and session snapshots are kept as files.
- Knowledge retrieval combines filesystem storage for documents with PostgreSQL for metadata and vectors.
- Automation and multi-agent runs store outputs as files and history in PostgreSQL.
- Features include auto-embeddings, vector search, environment branching, file storage, and cron jobs.
- Allows similarity search and HTTP calls directly from SQL queries.
- Enables cloning of entire environments, including data, files, and permissions.
- Supports file operations like upload, download, and mounting without S3 configuration.
- Offers distributed job scheduling from SQL or CLI.
- Zero setup required, with support for generating TypeScript or Python types.
- Quick start with one command for installation and database creation.
- Plugins like db9-bootstrap and my-claw-dash extend functionality for AI agents and observability.