Lets AI assistants manage Tiger Cloud Postgres services, run SQL queries, inspect schemas, and view logs and metrics.
Also known as timescale/tiger-cli, tiger-cli
- Stars
- 127
- Tools
- 20
- Downloads, 30 days
- —
- Latest version
- 0.27.0
- Last commit
- Nov 14, 2026
- License
- Apache-2.0
What is Tiger Cloud MCP?
Tiger Cloud lets AI assistants manage Tiger Cloud Postgres services, run SQL queries, inspect schemas, and view logs and metrics. It exposes 20 tools, such as service_list, service_get, service_create.
Summary generated from the project's README
About Tiger Cloud MCP server
Managing Tiger Cloud Postgres services through an AI assistant is what Tiger MCP enables for developers and database administrators. By connecting this server to clients like Claude Code, Cursor, or GitHub Copilot CLI, users can direct an agent to perform complex infrastructure tasks without leaving their coding environment. The server uses your existing Tiger CLI authentication, meaning once you run tiger auth login, the AI assistant gains the ability to interact with your cloud resources via stdio or streamable HTTP transport.
Administrators can use the server to control the entire service lifecycle, including creating, resizing, forking, or stopping database services. The toolset includes specific capabilities for inspecting database schemas, running SQL queries with db_query, and monitoring system health through service_logs and various metrics series. It also provides access to documentation through a proxied server, allowing the AI to search for PostgreSQL and TimescaleDB best practices to assist in troubleshooting or development.
What you can do with it
- 1Manage database service lifecyclesAsk your AI assistant to create a new database service or resize the CPU and memory of an existing one.
- 2Inspect database structures and extensionsHave an agent retrieve the full schema of your database including tables, views, and TimescaleDB hypertables.
- 3Monitor performance and logsRequest the AI to fetch time series metrics or view service logs to diagnose performance issues.
- 4Execute SQL queriesDirect an AI agent to run specific SQL queries against your Tiger Cloud services to validate data.
Written from the project's README. Every use case is checked against a quote from it.
How to install Tiger Cloud MCP
Formats verified 10 Nov 2026Add to CursorAdd to GooseInstall Tiger Cloud MCP in Claude Code
$ claude mcp add --env 'TIGER_SECRET_KEY=<YOUR_TIGER_SECRET_KEY>' --env 'TIGER_PUBLIC_KEY=<TIGER_PUBLIC_KEY>' tiger-cli -- docker run -i --rm ghcr.io/timescale/tiger-cli:0.27.0Install Tiger Cloud MCP in Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"tiger-cli": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/tiger-cli:0.27.0"
],
"env": {
"TIGER_SECRET_KEY": "<YOUR_TIGER_SECRET_KEY>",
"TIGER_PUBLIC_KEY": "<TIGER_PUBLIC_KEY>"
}
}
}
}Install Tiger Cloud MCP in VS Code
.vscode/mcp.json
{
"servers": {
"tiger-cli": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/tiger-cli:0.27.0"
],
"env": {
"TIGER_SECRET_KEY": "<YOUR_TIGER_SECRET_KEY>",
"TIGER_PUBLIC_KEY": "<TIGER_PUBLIC_KEY>"
}
}
}
}Install Tiger Cloud MCP in VS Code CLI
$ code --add-mcp '{"name":"tiger-cli","type":"stdio","command":"docker","args":["run","-i","--rm","ghcr.io/timescale/tiger-cli:0.27.0"],"env":{"TIGER_SECRET_KEY":"<YOUR_TIGER_SECRET_KEY>","TIGER_PUBLIC_KEY":"<TIGER_PUBLIC_KEY>"}}'Install Tiger Cloud MCP in Claude Desktop
claude_desktop_config.json
{
"mcpServers": {
"tiger-cli": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/tiger-cli:0.27.0"
],
"env": {
"TIGER_SECRET_KEY": "<YOUR_TIGER_SECRET_KEY>",
"TIGER_PUBLIC_KEY": "<TIGER_PUBLIC_KEY>"
}
}
}
}Install Tiger Cloud MCP in Codex
$ codex mcp add tiger-cli --env 'TIGER_SECRET_KEY=<YOUR_TIGER_SECRET_KEY>' --env 'TIGER_PUBLIC_KEY=<TIGER_PUBLIC_KEY>' -- docker run -i --rm ghcr.io/timescale/tiger-cli:0.27.0Install Tiger Cloud MCP in Codex config.toml
~/.codex/config.toml
[mcp_servers.tiger-cli] command = "docker" args = ["run", "-i", "--rm", "ghcr.io/timescale/tiger-cli:0.27.0"] [mcp_servers.tiger-cli.env] TIGER_SECRET_KEY = "<YOUR_TIGER_SECRET_KEY>" TIGER_PUBLIC_KEY = "<TIGER_PUBLIC_KEY>"
Install Tiger Cloud MCP in Gemini CLI
$ gemini mcp add -s user -e 'TIGER_SECRET_KEY=<YOUR_TIGER_SECRET_KEY>' -e 'TIGER_PUBLIC_KEY=<TIGER_PUBLIC_KEY>' tiger-cli docker -- run -i --rm ghcr.io/timescale/tiger-cli:0.27.0Install Tiger Cloud MCP in Gemini settings.json
~/.gemini/settings.json
{
"mcpServers": {
"tiger-cli": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/timescale/tiger-cli:0.27.0"
],
"env": {
"TIGER_SECRET_KEY": "<YOUR_TIGER_SECRET_KEY>",
"TIGER_PUBLIC_KEY": "<TIGER_PUBLIC_KEY>"
}
}
}
}Tiger Cloud MCP tools 20
Detected from the READMEservice_listservice_getservice_createservice_forkservice_startservice_stopservice_renameservice_resizeservice_deleteservice_update_passwordservice_logsservice_metrics_available
| service_list | — | |
| service_get | — | |
| service_create | — | |
| service_fork | — | |
| service_start | — | |
| service_stop | — | |
| service_rename | — | |
| service_resize | — | |
| service_delete | — | |
| service_update_password | — | |
| service_logs | — | |
| service_metrics_available | — |
Show all 20 toolsShow fewer tools
service_metrics_detailsservice_metrics_seriesdb_querydb_schemadb_extensions_listfeedbackview_skillsearch_docs
| service_metrics_details | — | |
| service_metrics_series | — | |
| db_query | — | |
| db_schema | — | |
| db_extensions_list | — | |
| feedback | — | |
| view_skill | — | |
| search_docs | — |
Configuration
TIGER_SECRET_KEYRequiredSecretTiger Cloud API secret key for authentication
TIGER_PUBLIC_KEYRequiredTiger Cloud API public key for authentication
| Name | Description | |
|---|---|---|
| TIGER_SECRET_KEY | Tiger Cloud API secret key for authentication | RequiredSecret |
| TIGER_PUBLIC_KEY | Tiger Cloud API public key for authentication | Required |
Automated checks
Ran Nov 12, 2026Full report →Passed our automated checks. That is not a security audit: read the code and give the server the narrowest access it needs. How checks work
- Source repository linked and reachablePass
- Open source license (OSI)Pass
- Commit or release in the last yearPass
- Package name not close to a popular packageNot checked
- Remote endpoint uses HTTPSNot checked
- Destructive tools are labelledPass
- No hidden instructions to the modelPass
- No critical advisory in the package or its dependenciesNot checked
README
View on GitHubTiger CLI
Tiger CLI is the command-line interface for Tiger Cloud. It provides commands for managing and querying database services, as well as an integrated Model Context Protocol (MCP) server for use with AI assistants.
Installation
Multiple installation methods are provided. Choose your preferred method from the options below. If you aren't sure, use the first one!
Install Script (macOS/Linux/WSL)
curl -fsSL https://cli.tigerdata.com | sh
Install Script (Windows)
irm https://cli.tigerdata.com/install.ps1 | iex
Homebrew (macOS/Linux)
brew install --cask timescale/tap/tiger-cli
Debian/Ubuntu
# Add repository
curl -s https://packagecloud.io/install/repositories/timescale/tiger-cli/script.deb.sh | sudo os=any dist=any bash
# Install tiger-cli
sudo apt-get install tiger-cli
For manual repository installation instructions, see here.
Red Hat/Fedora
# Add repository
curl -s https://packagecloud.io/install/repositories/timescale/tiger-cli/script.rpm.sh | sudo os=rpm_any dist=rpm_any bash
# Install tiger-cli
sudo yum install tiger-cli
For manual repository installation instructions, see here.
Go Install
go install github.com/timescale/tiger-cli/cmd/tiger@latest
Updating
To upgrade an existing installation to the latest release:
tiger upgrade
This downloads the latest published binary, verifies its checksum, and replaces the currently running binary in place. If Tiger CLI was installed via a package manager (Homebrew, apt, yum/dnf), tiger upgrade will instead point you at the matching package-manager command.
Quick Start
After installing Tiger CLI, authenticate with your Tiger Cloud account:
# Login to your Tiger account
tiger auth login
# View available commands
tiger --help
# List your database services
tiger service list
# Create a new database service
tiger service create --name my-database
# Get connection string
tiger db uri
# Connect to your database
tiger db psql
# Run a query without psql
tiger db query -c "SELECT now()"
# Install the MCP server
tiger mcp install
# Install agent skills for your coding agent
tiger skills install
Usage
Tiger CLI provides the following commands:
tiger auth- Authentication managementlogin- Log in to your Tiger account (use--headlessto authorize with a short code in a browser on any machine)logout- Log out from your Tiger accountstatus- Show current authentication status and project ID (alias:whoami)
tiger project- Project managementlist- List all projects you have access to, marking the active one (alias:ls)use- Switch the active project (requires an OAuth login; clears the defaultservice_id, since it belonged to the previous project) (alias:switch)
tiger service- Service lifecycle management (aliases:services,svc)list- List all services (alias:ls)create- Create a new serviceget- Show detailed service information (aliases:describe,show)fork- Fork an existing servicestart- Start a stopped service (alias:resume)stop- Stop a running service (alias:pause)rename- Rename a serviceresize- Resize service CPU and memory allocationdelete- Delete a service (alias:rm)update-password- Update service master passwordlogs- View service logs (alias:log)metrics available- List the metric names available for a servicemetrics details- Show a metric's description, type, default aggregation and labelsmetrics series- Fetch a metric's time series, with label filters, an aggregation function, group by and bucket size
tiger db- Database operationspsql- Connect to a database with psql (in an interactive terminal, if the service has read replicas, offers to connect to one of them; use--no-replica-promptto skip) (alias:connect)query- Execute a SQL query against a database and display the results, without needing psql (alias:sql)uri- Get connection URI for a service (alias:connection-string)ping- Test database connectivity (aliases:test,test-connection)schema- Display database schema information (tables, views, indexes, functions, TimescaleDB hypertables, and more)extensions list- List the PostgreSQL extensions installed in a database, with their versions and schemas (aliases:ext ls)save-password- Save a database password to configured password storage (keyring, pgpass, or none)create role- Create a new database role, with optional read-only enforcement, inherited grants (--from), and statement timeout (alias:create user)
tiger config- Configuration management (alias:cfg)list- List current configuration (aliases:ls,show)set- Set configuration valueunset- Remove configuration value (aliases:rm,delete)reset- Reset configuration to defaults (alias:clear)
tiger mcp- MCP server setup and managementinstall- Install and configure MCP server for an AI assistant (alias:add)start- Start the MCP serverlist- List available MCP tools, prompts, and resources (alias:ls)get- Get detailed information about a specific MCP capability (aliases:describe,show)
tiger skills- Agent skills for AI coding agentsinstall- Install PostgreSQL and TimescaleDB skills for AI coding agents (alias:add)
tiger feedback- Submit feedback or a bug report to the Tiger Data team (pass the message as an argument or on stdin)tiger version- Show version informationtiger upgrade- Upgrade the Tiger CLI to the latest version (alias:update)
Use tiger <command> --help for detailed information about each command, or browse the generated CLI reference.
Naming a Service
Anywhere a command takes a service as an argument, it takes either its ID (or a read replica set ID) or its name:
tiger db psql my-api-db
tiger service stop my-api-db
Names are matched exactly. A name that matches more than one service is refused; run tiger service list to find the ID you want. A default service (tiger config set service_id, --service-id, or TIGER_SERVICE_ID) must be an ID, and destructive commands still ask you to type the ID to confirm. The MCP tools take IDs only.
MCP Server
Tiger CLI includes a Model Context Protocol (MCP) server that enables AI assistants like Claude Code to interact with your Tiger Cloud infrastructure. The MCP server provides programmatic access to database services and operations.
Installation
Configure the MCP server for your AI assistant:
# Interactive installation (prompts for client selection)
tiger mcp install
# Or specify your client directly
tiger mcp install claude-code # Claude Code
tiger mcp install codex # Codex
tiger mcp install copilot # GitHub Copilot CLI
tiger mcp install cursor # Cursor IDE
tiger mcp install devin # Devin
tiger mcp install gemini # Gemini CLI
tiger mcp install pi # Pi 0.99.0 or later
tiger mcp install vscode # VS Code
After installation, restart your AI assistant to activate the Tiger MCP server.
Manual Installation
If your MCP client is not supported by tiger mcp install, follow the client's
instructions for installing MCP servers. Use tiger mcp start as the command to
start the MCP server. For example, many clients use a JSON file like the
following:
{
"mcpServers": {
"tiger": {
"command": "tiger",
"args": [
"mcp",
"start"
]
}
}
}
Streamable HTTP Protocol
The above instructions install the MCP server using the stdio transport. If you
need to use the Streamable HTTP transport instead, you can start the server with
tiger mcp start http --port 8080 and install it into your client using
http://localhost:8080 as the URL. Over HTTP the client may be on a different
machine, so db_query doesn't accept a SQL file path, only inline SQL.
Available MCP Tools
The MCP server exposes the following tools to AI assistants:
Service Management:
service_list- List all database services in your projectservice_get- Get detailed information about a specific serviceservice_create- Create new database services with configurable resourcesservice_fork- Fork an existing database service to create an independent copyservice_start- Start a stopped database serviceservice_stop- Stop a running database serviceservice_rename- Rename a database serviceservice_resize- Resize a database service by changing CPU and memory allocationservice_delete- Permanently delete a database service (asks you to confirm first if the service is tagged PROD)service_update_password- Set a new, randomly generated master password for a service (asks you to confirm first if the service is tagged PROD)service_logs- View logs for a database service
Service Metrics:
service_metrics_available- List the metric names available for a service (hardware usage, PostgreSQL settings and activity, PgBouncer pools, TimescaleDB internals)service_metrics_details- Show a metric's description, type, default aggregation and labelsservice_metrics_series- Fetch a metric's time series over a time window, with label filters, an aggregation function, group by and bucket size
Database Operations:
db_query- Execute SQL queries against a database service, passed inline or as a path to a SQL file within the server's working directory, with support for parameterized queries, custom timeouts, and connection poolingdb_schema- Display a service's database schema (tables, views, materialized views, enums, functions, procedures, indexes, triggers, and TimescaleDB hypertable/continuous aggregate metadata) as readable text for an agent's contextdb_extensions_list- List the PostgreSQL extensions installed in a service database, with each extension's version, schema, and description
Feedback:
feedback- Submit feedback or a bug report to the Tiger Data team
The MCP server automatically uses your CLI authentication and configuration, so no additional setup is required beyond tiger auth login.
Proxied Tools
In addition to the service management tools listed above, the Tiger MCP server also proxies tools from a remote documentation MCP server. This feature provides AI assistants with semantic search capabilities for PostgreSQL, TimescaleDB, and Tiger Cloud documentation, as well as prompts/guides for various Tiger Cloud features.
The proxied documentation server (pg-aiguide) currently provides the following tools:
view_skill- Retrieve comprehensive guides for Postgres and TimescaleDB features and best practicessearch_docs- Search PostgreSQL and TimescaleDB documentation using natural language queries
This proxy connection is enabled by default and requires no additional configuration.
To disable the documentation proxy:
tiger config set docs_mcp false
Agent Skills
Tiger CLI can install curated PostgreSQL and TimescaleDB skills directly into your coding agents:
# Interactive installation (prompts for install locations)
tiger skills install
# Or name the locations directly
tiger skills install universal claude-code
Skills are installed for the current user. The universal location,
~/.agents/skills, is read by most coding agents (Cursor, Codex, Gemini CLI,
VS Code, GitHub Copilot CLI, Devin, Pi). Claude Code, Kiro CLI, and Google
Antigravity read their own skills directories, so they're separate locations
(claude-code, kiro-cli, antigravity). Naming a client that reads
~/.agents/skills, such as cursor, selects universal. Use --skills-dir
to install into a directory of your choice instead.
Re-run the command to update the skills to the latest version; skills that are
no longer available are removed. With no arguments, the locations you've
installed to before are selected in the picker to start with. Existing skills
that weren't installed by Tiger CLI are never replaced unless you pass
--force.
Configuration
The CLI stores configuration in ~/.config/tiger/config.yaml by default, and supports hierarchical configuration through environment variables and command-line flags.
# List current configuration
tiger config list
# Set configuration values
tiger config set output json
# Remove configuration value
tiger config unset output
# Reset to defaults
tiger config reset
Configuration Options
All configuration options can be set via tiger config set <key> <value>:
-
analytics- Enable/disable analytics (default:true) -
color- Enable/disable colored output (default:true) -
docs_mcp- Enable/disable docs MCP proxy (default:true) -
mcp_max_rows- Maximum number of rows thedb_queryMCP tool returns per result set before truncating, to limit how much data lands in an AI agent's context. Only applies to the MCP tool, not CLI commands. Default:100 -
output- Output format:json,yaml, ortable(default:table) -
password_storage- Password storage method:keyring,pgpass, ornone(default:keyring) -
read_only- Which services this CLI may change:all,prod, oroff(default:off, which protects nothing). An interactivetiger auth loginoffers a menu of the three modes, and records your choice either way, so it only asks until you answer once.trueandonare accepted as aliases forall, andfalseforoff, so existing config files andTIGER_READ_ONLY=truebehave as before.Changing a protected service is refused, and so is creating one:
tiger service create/fork/start/stop/rename/resize/update-password/deleteandtiger db create rolereturn an error. Connection strings for it open the session in Tiger Cloud's immutable read-only mode, so the server rejects writes and DDL — that coverstiger db psql,tiger db query,tiger db uri, thedb_queryMCP tool, and the connection strings embedded intiger serviceoutput and the equivalent MCP tools.allprotects every service, and the MCP write tools aren't registered at all, so they don't appear intools/listand can't be called.prodprotects only services taggedPROD, leavingDEVservices writable.tiger service create/forkand theservice_create/service_forkMCP tools are gated on the environment they request, so creating aDEVservice is allowed and aPRODone is not — otherwise you could create a service this same mode then refuses to delete. Forking aPRODservice into aDEVfork is allowed, since that reads production without changing it. The MCP write tools stay registered — they still work onDEVservices — and refuse per call instead. These commands read the tag off the service they resolve, so the tag costs no extra API call, and the operation is refused if that lookup fails. The MCP write tools, which take IDs, fetch the service to read its tag. A read replica is judged on its own tag, so a replica of aPRODprimary is protected only if that replica set is itself taggedPROD.
-
service_id- Default service ID. Cleared automatically when the active project changes: bytiger project, and bytiger auth loginunless it lands on the same project as the previous login. A service belongs to the project it was created in -
version_check- Whentrue, the CLI checks for a newer version on each invocation (in an interactive terminal) and prints a notice if one is available. Set tofalseto disable. Default:true.
Environment Variables
Environment variables override configuration file values. All variables use the TIGER_ prefix:
TIGER_ANALYTICS- Enable/disable analyticsTIGER_COLOR- Enable/disable colored outputTIGER_CONFIG_DIR- Path to configuration directory (default:~/.config/tiger)TIGER_DOCS_MCP- Enable/disable docs MCP proxyTIGER_OUTPUT- Output format:json,yaml, ortableTIGER_PASSWORD_STORAGE- Password storage method:keyring,pgpass, ornoneTIGER_READ_ONLY- Which services this CLI may change:all,prod, oroff(same aliases asread_only)TIGER_PUBLIC_KEY- Public key to use for authentication (takes priority over stored credentials)TIGER_SECRET_KEY- Secret key to use for authentication (takes priority over stored credentials)TIGER_SERVICE_ID- Default service ID (a name is refused; see Naming a Service)TIGER_VERSION_CHECK- Whentrue, the CLI checks for a newer version on each invocation (in an interactive terminal) and prints a notice if one is available;falseto disable
Global Flags
These flags are available on all commands and take precedence over both environment variables and configuration file values:
--analytics- Enable/disable analytics--color- Enable/disable colored output--config-dir <path>- Path to configuration directory (default:~/.config/tiger)--password-storage <method>- Password storage method:keyring,pgpass, ornone--service-id <id>- Service ID (a name is refused; pass one as an argument instead)--version-check- Enable/disable checking for updates on startup-h, --help- Show help information
Contributing
We welcome contributions! Here's how to get started:
- Fork the repository
- Create a feature branch
- Make your changes
- Add tests for new functionality
- Ensure all tests pass (
go test ./...) - Submit a pull request
For detailed development information, see docs/development.md.
License
This project is licensed under the Apache License 2.0 - see the LICENSE file for details.
Tiger Cloud MCP questions
How do I add Tiger Cloud MCP to Claude Code?
Run claude mcp add --env 'TIGER_SECRET_KEY=<YOUR_TIGER_SECRET_KEY>' --env 'TIGER_PUBLIC_KEY=<TIGER_PUBLIC_KEY>' tiger-cli -- docker run -i --rm ghcr.io/timescale/tiger-cli:0.27.0 in your terminal. Add --scope user to make it available in every project.
How do I add Tiger Cloud MCP to Cursor?
Open ~/.cursor/mcp.json and add the server under mcpServers, using the Cursor config shown in the install section above.
What tools does Tiger Cloud MCP provide?
It exposes 20 tools, including service_list, service_get, service_create, service_fork, service_start.
How do I install the Tiger MCP server in Claude Code?
Run tiger mcp install claude-code to configure the MCP server for Claude Code, then restart the assistant to activate it.
What can the Tiger MCP server do with database services?
It exposes tools to list, create, fork, start, stop, rename, resize, and delete database services, as well as view service logs.
Can the Tiger MCP server run SQL queries?
Yes, the db_query tool executes SQL against a database service inline or from a SQL file, with parameterized queries, custom timeouts, and connection pooling.
Do I need separate authentication for the MCP server?
No, the MCP server uses your CLI authentication and configuration after you run tiger auth login.