Skip to content

timescale/ghost

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Ghost CLI

The official CLI for Ghost — the first database built for agents. Offers unlimited Postgres databases you can create, fork, and discard freely.

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

npm

npm install -g @ghost.build/cli

Usage

ghost login       # Authenticate with GitHub OAuth
ghost mcp install # Install the MCP server
ghost create      # Create a new Postgres database
ghost list        # List all databases

Commands

Command Description
api-key Manage API keys
completion Generate the autocompletion script for the specified shell
config List current configuration
connect Get connection string for a database
create Create a new Postgres database
delete Delete a database
feedback Submit feedback, a bug report, or a support request
fork Fork a database
help Help about any command
list List all databases
logs View logs for a database
login Authenticate with GitHub OAuth
logout Remove stored credentials
mcp Ghost Model Context Protocol (MCP) server
password Reset the password for a database
psql Connect to a database using psql
rename Rename a database
resume Resume a paused database
schema Display database schema information
sql Execute SQL query on a database
status Show space usage
version Show version information

Run ghost [command] --help for more information about a command.

MCP

The ghost mcp command installs a Model Context Protocol server so AI assistants like Claude can manage and query your databases directly.

Tool Description
ghost_login Authenticate with GitHub OAuth
ghost_list List all databases
ghost_status Show space usage
ghost_create Create a new database
ghost_delete Delete a database permanently
ghost_fork Fork a database
ghost_resume Resume a paused database
ghost_rename Rename a database
ghost_connect Get a connection string for a database
ghost_sql Execute a SQL query against a database
ghost_schema Display database schema information
ghost_password Reset the password for a database
ghost_logs View logs for a database
ghost_feedback Submit feedback, a bug report, or a support request
search_docs Search PostgreSQL, PostGIS, and TimescaleDB documentation
view_skill Retrieve skills for PostgreSQL and TimescaleDB best practices

Run ghost mcp list to see the full list of available tools and prompts, or ghost mcp get <name> for details on a specific one.

Contributing

Bug reports and feature requests are welcome — please open an issue.

License

Licensed under Apache 2.0.

About

Ghost 👻

Resources

License

Stars

Watchers

Forks

Packages

 
 
 

Contributors