ghost-database

Featured

Use this skill for persistent PostgreSQL storage in agent workflows — spin up databases on demand, test schema migrations safely on forks, and pass databases as assets between agents using Ghost. **Trigger when user asks to:** - Create a new PostgreSQL database quickly - Manage database lifecycle in agent workflows - Fork a database to test changes safely - Run analytics or heavy queries on a fork without impacting the production database - Share a database snapshot so others can spin up their own copy - Pass a database as an input or output between agents - Create a database for agents - Need many databases that are billed only when queried - Set up the Ghost MCP server or CLI **Note:** If the Ghost MCP server is already installed, use its tools directly — this skill is for environments without the MCP or as a reference for what's possible. **Keywords:** Ghost, ghost.build, database, create database, fork database, PostgreSQL, managed Postgres, MCP, agent database, connection string

API & Backend 1,835 stars 106 forks Updated 2 days ago Apache-2.0

Install

View on GitHub

Quality Score: 96/100

Stars 20%

100

Recency 20%

100

Frontmatter 20%

Documentation 15%

100

Issue Health 10%

License 10%

100

Description 5%

100

Skill Content

# Ghost Database Management Ghost is a managed PostgreSQL service designed for agents. Your account is organized into Spaces, each with unlimited on-demand databases and forks sharing a pool of compute hours (billed in 15-minute chunks when queries are executed). Free tier: 100 hours/month, 1TB storage. When you need continuous operation, promote any database to a **dedicated instance** — a separately billed, always-on database. Additional features: - **CLI and MCP native:** create and query databases from the terminal or any MCP-compatible agent - **Instant forking:** full database copies in seconds for safe experimentation - **Shareable snapshots:** share a database snapshot via URL — anyone with the link can spin up their own copy in their own space - **MCP read-only mode:** `ghost config set read_only true` locks all MCP tools into read-only — SQL queries execute in read-only mode and destructive tools (`ghost_delete`, `ghost_password`, `ghost_rename`) are blocked Website: https://ghost.build ## Installation Multiple installation methods are provided. If you aren't sure, use the first one. ### Install Script (macOS/Linux/WSL) ```bash curl -fsSL https://install.ghost.build | sh ``` ### Install Script (Windows PowerShell) ```powershell irm https://install.ghost.build/install.ps1 | iex ``` ### Debian/Ubuntu ```bash curl -s https://packagecloud.io/install/repositories/timescale/ghost/script.deb.sh | sudo os=any dist=any bash sudo apt-get install ghost ``` ### Red...