ghost-database

ghost-database is a skill for Claude Code, Codex from timescale/pg-aiguide. It costs 208 tokens per session (1,991 once invoked), scanned D, original, Apache-2.0.

A guide to Ghost, a managed PostgreSQL service for creating, testing, copying, sharing, and controlling databases in agent workflows.

In plain words
What is it for?
Use it to create or query databases, fork them for testing, share snapshots, promote a database to continuous operation, or enable read-only access.
Why use it?
It provides temporary database environments and safe forks so experiments and migrations can be tested without risking the main database.

Skill for Claude CodeCodex

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/timescale/pg-aiguide/ghost-database
Any agent
npx skills add timescale/pg-aiguide --skill ghost-database
Clone the repo
git clone --depth 1 https://github.com/timescale/pg-aiguide

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for ghost-database

README.md
[![agentmods](https://agentmods.dev/badge/skills/timescale/pg-aiguide/ghost-database.svg)](https://agentmods.dev/skills/timescale/pg-aiguide/ghost-database)
Your own site
<a href="https://agentmods.dev/skills/timescale/pg-aiguide/ghost-database"><img src="https://agentmods.dev/badge/skills/timescale/pg-aiguide/ghost-database.svg" alt="Measured on agentmods" height="20"></a>
Per session 208 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,991 The whole file, excluding the scripts and references it only reads on demand.
Security scan D 3 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00208 $0.01991
Opus 5 $0.00104 $0.00996
Sonnet 5 $0.00042 $0.00398
Haiku 4.5 $0.00021 $0.00199

Measured 4d ago against content hash c16ac8e9de7c, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade D, and why

ghost-database scanned grade D with 3 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 4d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Asks for rootmediumPrivilege escalation

A mod that escalates privileges can change anything on the machine, not only the project.

curl -s https://packagecloud.io/install/repositories/timescale/ghost/script.deb.sh | sudo os=any dist=any bash

Downloads and executes remote codehighSupply chain

curl | sh runs whatever the server returns today, which is not necessarily what it returned when this was reviewed.

curl -fsSL https://install.ghost.build | sh

Makes network callslowCapability

Not a fault in itself. Listed so you know the mod talks to something, and to what.

curl -fsSL https://install.ghost.build | sh
skills/ghost-database/SKILL.md · 260 lines

How it starts

The opening of the file, as written. The whole thing — 260 lines — stays where its author put it; the contents beside it link to each section on GitHub.

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)

curl -fsSL https://install.ghost.build | sh

Install Script (Windows PowerShell)

irm https://install.ghost.build/install.ps1 | iex

Debian/Ubuntu

curl -s https://packagecloud.io/install/repositories/timescale/ghost/script.deb.sh | sudo os=any dist=any bash
sudo apt-get install ghost

Red Hat/Fedora

curl -s https://packagecloud.io/install/repositories/timescale/ghost/script.rpm.sh | sudo os=rpm_any dist=rpm_any bash
sudo yum install ghost

Getting Started

CLI

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

MCP

ghost_login()                   // Authenticate with GitHub
ghost_create({ name: "my-db" }) // → returns { id: "abc123", ... }
ghost_list()                    // List all databases with their IDs
ghost_connect({ name_or_id: "abc123" }) // Get connection string

Read the full file on GitHub · 260 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 4d ago First seen · 260 lines · 208 tokens per session scan D c16ac8e9de7c

Subscribe to this mod's changes

ghost-database is a skill published in the GitHub repository timescale/pg-aiguide (1,833 stars, last pushed yesterday), licensed Apache-2.0. It adds 208 tokens to every session and 1,991 once invoked, about $0.0010 per session on Opus 5. A static security scan graded it D with 3 findings (asks for root, downloads and executes remote code, makes network calls). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

lark-base

飞书多维表格(Base)操作:建表、字段、记录、视图、统计、公式/lookup、表单、仪表盘、workflow、角色权限;遇到 Base/多维表格/bitable 或 /base/ 链接时使用。文件导入/导出转 lark-drive,认证/授权转 lark-shared。.

DropFan/claude-code-plugins · 84 tokens

lyric-writer

Writes or reviews lyrics with professional prosody, rhyme craft, and quality checks. Use when writing new lyrics, revising existing lyrics, or when the user says 'let's work on a track.'.

bitwize-music-studio/claude-ai-music-skills · 45 tokens

lyric-refiner

Autonomous multi-pass lyric refinement for tightening, cohesion, and album unity. Use after lyrics are written to polish a track or entire album through iterative passes.

bitwize-music-studio/claude-ai-music-skills · 36 tokens

mastering-engineer

Guides audio mastering for streaming platforms including loudness optimization and tonal balance. Use when the user has approved tracks and wants to master audio files.

bitwize-music-studio/claude-ai-music-skills · 34 tokens

suno-engineer

Constructs technical Suno V5/V5.5 style prompts, selects genres, and optimizes generation settings. Use when creating or refining Suno prompts for track generation.

bitwize-music-studio/claude-ai-music-skills · 40 tokens

album-art-director

Creates visual concepts for album artwork and generates AI art prompts. Use during planning for concept discussion, or after all tracks are Final for actual artwork generation.

bitwize-music-studio/claude-ai-music-skills · 35 tokens