Agent skill · Testing & QA

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

Tiger Data1,796★ · +6/wk · 1 repos on radarProfile →
claude-codeApache-2.0
Install
npx skills add timescale/pg-aiguide --skill ghost-database --agent claude-code

Same command for any agent — swap --agent for codex, cursor, copilot.

Facts
Files in the skill folder: 1
SKILL.md size: 8 KB
Bundled scripts: none
Declared author: tigerdata
Path: skills/ghost-database/SKILL.md
Open the folder on GitHub →
Where it comes from
Stars: 1,806 · +10 this week
Language: Python
Read our review of the source →

Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.

From the SKILL.md

# 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

What's inside
Steps it walks through
  1. Installation
  2. Install Script (macOS/Linux/WSL)
  3. Install Script (Windows PowerShell)
  4. Debian/Ubuntu
  5. Red Hat/Fedora
  6. Getting Started
  7. Core Workflows
  8. Create and Query a Database
  9. Fork for Safe Experimentation
  10. Auto-Pause and Resume
  11. Inspect Schema
  12. Share a Database
  13. CLI Command Reference
  14. MCP Integration
Commands it runs
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)
More from pg-aiguide
All skills →
About this skill
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.

Keep going