ghost-database
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
npx skills add timescale/pg-aiguide --skill ghost-database --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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
- Installation
- Install Script (macOS/Linux/WSL)
- Install Script (Windows PowerShell)
- Debian/Ubuntu
- Red Hat/Fedora
- Getting Started
- Core Workflows
- Create and Query a Database
- Fork for Safe Experimentation
- Auto-Pause and Resume
- Inspect Schema
- Share a Database
- CLI Command Reference
- MCP Integration
curl -fsSL https://install.ghost.build | sh curl -s https://packagecloud.io/install/repositories/timescale/ghost/script.deb.sh | sudo os=any dist=any bash sudo apt-get install ghost curl -s https://packagecloud.io/install/repositories/timescale/ghost/script.rpm.sh | sudo os=rpm_any dist=rpm_any bash sudo yum install ghost ghost login # Authenticate with GitHub ghost create # Create a new database (returns an ID, e.g. abc123) ghost list # List all databases with their IDs ghost connect <name-or-id> # Get connection string Create a database (returns an ID like abc123)
What does the ghost-database skill do?
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
How do I install it?
Run `npx skills add timescale/pg-aiguide --skill ghost-database --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From timescale/pg-aiguide, a repository with 1,806 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.