Tiger Data MCP Server
About
The Tiger MCP server provides mcp tools for managing and querying Postgres database services on tiger cloud. Tiger cloud is the best PostgreSQL cloud provider for Developers,
Details
- Author
- timescale
- Downloads
- 206
- Categories
- Database
Jump to
- Service management tools (list, get, create, fork, start, stop, update password)
- SQL execution tool with parameterized queries and timeouts
- Automatic documentation proxy for PostgreSQL and Tiger Cloud guides
- Zero additional configuration—uses existing CLI authentication
- Supports connection pooling and custom query timeouts
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Tiger Data MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
After installing the Tiger CLI (curl -fsSL https://cli.tigerdata.com | sh) and authenticating (tiger auth login), run tiger mcp install to install the server with your preferred coding tool. All tools are then available through the MCP interface.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"tiger data mcp server": {
"tiger": {
"command": "tiger",
"args": [
"mcp",
"start"
]
}
}
}
}
McpServers
{
"tiger": {
"command": "tiger",
"args": [
"mcp",
"start"
]
}
}
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.
Multiple installation methods are provided. Choose your preferred method from the options below. If you aren't sure, use the first one!
curl -fsSL https://cli.tigerdata.com | sh
irm https://cli.tigerdata.com/install.ps1 | iex
brew install --cask timescale/tap/tiger-cli
# 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, seehere.
# 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, seehere.
go install github.com/timescale/tiger-cli/cmd/tiger@latest
To upgrade an existing installation to the latest release:
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 upgradewill instead point you at the matching package-manager command.
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 connection-string # Connect to your database tiger db connect # Install the MCP server tiger mcp install
Tiger CLI provides the following commands:
- tiger auth- Authentication management
- login- Log in to your Tiger account
- logout- Log out from your Tiger account
- status- Show current authentication status and project ID (alias:whoami)
- list- List all services (alias:ls)
- create- Create a new service
- get- Show detailed service information (aliases:describe,show)
- fork- Fork an existing service
- start- Start a stopped service (alias:resume)
- stop- Stop a running service (alias:pause)
- resize- Resize service CPU and memory allocation
- delete- Delete a service (alias:rm)
- update-password- Update service master password
- logs- View service logs (alias:log)
- connect- 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:psql)
- connection-string- Get connection string for a service (alias:uri)
- test-connection- Test database connectivity (aliases:test,ping)
- schema- Display database schema information (tables, views, indexes, functions, TimescaleDB hypertables, and more)
- 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)
- show- Show current configuration (aliases:list,ls)
- set- Set configuration value
- unset- Remove configuration value (aliases:rm,delete)
- reset- Reset configuration to defaults (alias:clear)
- install- Install and configure MCP server for an AI assistant (alias:add)
- start- Start the MCP server
- list- List available MCP tools, prompts, and resources (alias:ls)
- get- Get detailed information about a specific MCP capability (aliases:describe,show)
Usetiger <command> --helpfor detailed information about each command.
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.
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 cursor # Cursor IDE tiger mcp install gemini # Gemini CLI tiger mcp install vscode # VS Code tiger mcp install windsurf # Windsurf
After installation, restart your AI assistant to activate the Tiger MCP server.
If your MCP client is not supported bytiger mcp install, follow the client's instructions for installing MCP servers. Usetiger mcp startas 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" ] } } }
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 withtiger mcp start http --port 8080and install it into your client usinghttp://localhost:8080as the URL.
The MCP server exposes the following tools to AI assistants:
- service_list- List all database services in your project
- service_get- Get detailed information about a specific service
- service_create- Create new database services with configurable resources
- service_fork- Fork an existing database service to create an independent copy
- service_start- Start a stopped database service
- service_stop- Stop a running database service
- service_resize- Resize a database service by changing CPU and memory allocation
- service_update_password- Update the master password for a service
- service_logs- View logs for a database service
- db_execute_query- Execute SQL queries against a database service with support for parameterized queries, custom timeouts, and connection pooling
- db_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 context
The MCP server automatically uses your CLI authentication and configuration, so no additional setup is required beyondtiger auth login.
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 practices
- search_docs- Search PostgreSQL and TimescaleDB documentation using natural language queries
This proxy connection is enabled by default and requires no additional configuration.
The CLI stores configuration in~/.config/tiger/config.yamlby default, and supports hierarchical configuration through environment variables and command-line flags.
# Show current configuration tiger config show # Set configuration values tiger config set output json # Remove configuration value tiger config unset output # Reset to defaults tiger config reset
All configuration options can be set viatiger 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_execute_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- Whentrue, mutating operations are refused: thetiger service create/fork/start/stop/resize/update-password/deleteCLI commands return an error, and their MCP equivalents are not registered, so they don't appear intools/listand can't be called.tiger db connect,tiger db connection-string, and thedb_execute_queryMCP tool open the database session in Tiger Cloud's immutable read-only mode (writes and DDL are rejected by the server). Read commands/tools are unaffected —tiger db schemaand thedb_schemaMCP tool always open a read-only session regardless of this setting. Default:false.
- service_id- Default service ID
- 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 override configuration file values. All variables use theTIGER_prefix:
- TIGER_ANALYTICS- Enable/disable analytics
- TIGER_COLOR- Enable/disable colored output
- TIGER_CONFIG_DIR- Path to configuration directory (default:~/.config/tiger)
- TIGER_DOCS_MCP- Enable/disable docs MCP proxy
- TIGER_OUTPUT- Output format:json,yaml, ortable
- TIGER_PASSWORD_STORAGE- Password storage method:keyring,pgpass, ornone
- TIGER_READ_ONLY- Whentrue, write/destructive CLI commands return an error, the corresponding Tiger MCP write tools are not registered, anddb_execute_queryruns against a read-only database connection
- 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
- 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
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>- Specify service ID
- --skip-update-check- Skip checking for updates on startup (default:false)
- -h, --help- Show help information
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, seedocs/development.md.
This project is licensed under the Apache License 2.0 - see theLICENSEfile for details.
Official Airtable MCP server and skills for working with bases, records, workflows, and business operations from AI agents.
MCP Server For Apache Doris, an MPP-based real-time data warehouse.
Official MCP Server from Atlan which enables you to bring the power of metadata to your AI tools
Query Onchain data, like ERC20 tokens, transaction history, smart contract state.
Read and write access to your Baserow tables.
Introspect and query your apps deployed to Convex.
Interact with the data stored in Couchbase clusters using natural language.
Maritime intelligence for tracking vessels, analysing ports, and exploring ship data.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.



