{
  "markdown": "# Tiger CLI\n\nTiger 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.\n\n## Installation\n\nMultiple installation methods are provided. Choose your preferred method from the options below. If you aren't sure, use the first one!\n\n### Install Script (macOS/Linux/WSL)\n\n```bash\ncurl -fsSL https://cli.tigerdata.com | sh\n```\n\n### Install Script (Windows)\n\n```powershell\nirm https://cli.tigerdata.com/install.ps1 | iex\n```\n\n### Homebrew (macOS/Linux)\n\n```bash\nbrew install --cask timescale/tap/tiger-cli\n```\n\n### Debian/Ubuntu\n\n```bash\n# Add repository\ncurl -s https://packagecloud.io/install/repositories/timescale/tiger-cli/script.deb.sh | sudo os=any dist=any bash\n\n# Install tiger-cli\nsudo apt-get install tiger-cli\n```\n\nFor manual repository installation instructions, see [here](https://packagecloud.io/timescale/tiger-cli/install#manual-deb).\n\n### Red Hat/Fedora\n\n```bash\n# Add repository\ncurl -s https://packagecloud.io/install/repositories/timescale/tiger-cli/script.rpm.sh | sudo os=rpm_any dist=rpm_any bash\n\n# Install tiger-cli\nsudo yum install tiger-cli\n```\n\nFor manual repository installation instructions, see [here](https://packagecloud.io/timescale/tiger-cli/install#manual-rpm).\n\n### Go Install\n\n```bash\ngo install github.com/timescale/tiger-cli/cmd/tiger@latest\n```\n\n## Updating\n\nTo upgrade an existing installation to the latest release:\n\n```bash\ntiger upgrade\n```\n\nThis 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.\n\n## Quick Start\n\nAfter installing Tiger CLI, authenticate with your Tiger Cloud account:\n\n```bash\n# Login to your Tiger account\ntiger auth login\n\n# View available commands\ntiger --help\n\n# List your database services\ntiger service list\n\n# Create a new database service\ntiger service create --name my-database\n\n# Get connection string\ntiger db connection-string\n\n# Connect to your database\ntiger db connect\n\n# Install the MCP server\ntiger mcp install\n```\n\n## Usage\n\nTiger CLI provides the following commands:\n\n- `tiger auth` - Authentication management\n  - `login` - Log in to your Tiger account\n  - `logout` - Log out from your Tiger account\n  - `status` - Show current authentication status and project ID (alias: `whoami`)\n- `tiger project` - Project management\n  - `list` - List all projects you have access to, marking the active one (alias: `ls`)\n  - `use` - Switch the active project (requires an OAuth login; clears the default `service_id`, since it belonged to the previous project) (alias: `switch`)\n- `tiger service` - Service lifecycle management (aliases: `services`, `svc`)\n  - `list` - List all services (alias: `ls`)\n  - `create` - Create a new service\n  - `get` - Show detailed service information (aliases: `describe`, `show`)\n  - `fork` - Fork an existing service\n  - `start` - Start a stopped service (alias: `resume`)\n  - `stop` - Stop a running service (alias: `pause`)\n  - `resize` - Resize service CPU and memory allocation\n  - `delete` - Delete a service (alias: `rm`)\n  - `update-password` - Update service master password\n  - `logs` - View service logs (alias: `log`)\n- `tiger db` - Database operations\n  - `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-prompt` to skip) (alias: `psql`)\n  - `connection-string` - Get connection string for a service (alias: `uri`)\n  - `test-connection` - Test database connectivity (aliases: `test`, `ping`)\n  - `schema` - Display database schema information (tables, views, indexes, functions, TimescaleDB hypertables, and more)\n  - `save-password` - Save a database password to configured password storage (keyring, pgpass, or none)\n  - `create role` - Create a new database role, with optional read-only enforcement, inherited grants (`--from`), and statement timeout (alias: `create user`)\n- `tiger config` - Configuration management (alias: `cfg`)\n  - `show` - Show current configuration (aliases: `list`, `ls`)\n  - `set` - Set configuration value\n  - `unset` - Remove configuration value (aliases: `rm`, `delete`)\n  - `reset` - Reset configuration to defaults (alias: `clear`)\n- `tiger mcp` - MCP server setup and management\n  - `install` - Install and configure MCP server for an AI assistant (alias: `add`)\n  - `start` - Start the MCP server\n  - `list` - List available MCP tools, prompts, and resources (alias: `ls`)\n  - `get` - Get detailed information about a specific MCP capability (aliases: `describe`, `show`)\n- `tiger version` - Show version information\n- `tiger upgrade` - Upgrade the Tiger CLI to the latest version (alias: `update`)\n\nUse `tiger <command> --help` for detailed information about each command.\n\n## MCP Server\n\nTiger 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.\n\n### Installation\n\nConfigure the MCP server for your AI assistant:\n\n```bash\n# Interactive installation (prompts for client selection)\ntiger mcp install\n\n# Or specify your client directly\ntiger mcp install claude-code    # Claude Code\ntiger mcp install codex          # Codex\ntiger mcp install cursor         # Cursor IDE\ntiger mcp install gemini         # Gemini CLI\ntiger mcp install vscode         # VS Code\ntiger mcp install windsurf       # Windsurf\n```\n\nAfter installation, restart your AI assistant to activate the Tiger MCP server.\n\n#### Manual Installation\n\nIf your MCP client is not supported by `tiger mcp install`, follow the client's\ninstructions for installing MCP servers. Use `tiger mcp start` as the command to\nstart the MCP server. For example, many clients use a JSON file like the\nfollowing:\n\n\n```json\n{\n  \"mcpServers\": {\n    \"tiger\": {\n      \"command\": \"tiger\",\n      \"args\": [\n        \"mcp\",\n        \"start\"\n      ]\n    }\n  }\n}\n```\n\n#### Streamable HTTP Protocol\n\nThe above instructions install the MCP server using the stdio transport. If you\nneed to use the Streamable HTTP transport instead, you can start the server with\n`tiger mcp start http --port 8080` and install it into your client using\n`http://localhost:8080` as the URL.\n\n### Available MCP Tools\n\nThe MCP server exposes the following tools to AI assistants:\n\n**Service Management:**\n- `service_list` - List all database services in your project\n- `service_get` - Get detailed information about a specific service\n- `service_create` - Create new database services with configurable resources\n- `service_fork` - Fork an existing database service to create an independent copy\n- `service_start` - Start a stopped database service\n- `service_stop` - Stop a running database service\n- `service_resize` - Resize a database service by changing CPU and memory allocation\n- `service_update_password` - Update the master password for a service\n- `service_logs` - View logs for a database service\n\n**Database Operations:**\n- `db_execute_query` - Execute SQL queries against a database service with support for parameterized queries, custom timeouts, and connection pooling\n- `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\n\nThe MCP server automatically uses your CLI authentication and configuration, so no additional setup is required beyond `tiger auth login`.\n\n#### Proxied Tools\n\nIn 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.\n\nThe proxied documentation server ([pg-aiguide](https://github.com/timescale/pg-aiguide)) currently provides the following tools:\n- `view_skill` - Retrieve comprehensive guides for Postgres and TimescaleDB features and best practices\n- `search_docs` - Search PostgreSQL and TimescaleDB documentation using natural language queries\n\nThis proxy connection is enabled by default and requires no additional configuration.\n\nTo disable the documentation proxy:\n\n```bash\ntiger config set docs_mcp false\n```\n\n## Configuration\n\nThe CLI stores configuration in `~/.config/tiger/config.yaml` by default, and supports hierarchical configuration through environment variables and command-line flags.\n\n```bash\n# Show current configuration\ntiger config show\n\n# Set configuration values\ntiger config set output json\n\n# Remove configuration value\ntiger config unset output\n\n# Reset to defaults\ntiger config reset\n```\n\n### Configuration Options\n\nAll configuration options can be set via `tiger config set <key> <value>`:\n\n- `analytics` - Enable/disable analytics (default: `true`)\n- `color` - Enable/disable colored output (default: `true`)\n- `docs_mcp` - Enable/disable docs MCP proxy (default: `true`)\n- `mcp_max_rows` - Maximum number of rows the `db_execute_query` MCP 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`\n- `output` - Output format: `json`, `yaml`, or `table` (default: `table`)\n- `password_storage` - Password storage method: `keyring`, `pgpass`, or `none` (default: `keyring`)\n- `read_only` - Which services this CLI may change: `all`, `prod`, or `off` (default: `off`, which protects nothing). An interactive `tiger auth login` offers a menu of the three modes, and records your choice either way, so it only asks until you answer once. `true` and `on` are accepted as aliases for `all`, and `false` for `off`, so existing config files and `TIGER_READ_ONLY=true` behave as before.\n\n  Changing a protected service is refused, and so is creating one: `tiger service create`/`fork`/`start`/`stop`/`resize`/`update-password`/`delete` and `tiger db create role` return 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 covers `tiger db connect`, `tiger db connection-string`, the `db_execute_query` MCP tool, and the connection strings embedded in `tiger service` output and the equivalent MCP tools.\n\n  - `all` protects every service, and the MCP write tools aren't registered at all, so they don't appear in `tools/list` and can't be called.\n  - `prod` protects only services tagged `PROD`, leaving `DEV` services writable. `tiger service create`/`fork` are gated on the `--environment` they request, so creating a `DEV` service is allowed and a `PROD` one is not — otherwise you could create a service this same mode then refuses to delete. Forking a `PROD` service into a `DEV` fork is allowed, since that reads production without changing it. The MCP write tools stay registered — they still work on `DEV` services — and refuse per call instead. Reading a service's tag costs one extra API call for `tiger service start`/`stop`/`resize`/`delete`, and the operation is refused if that lookup fails. A read replica is judged on its own tag, so a replica of a `PROD` primary is protected only if that replica set is itself tagged `PROD`.\n\n- `service_id` - Default service ID. Cleared automatically when the active project changes: by `tiger project`, and by `tiger auth login` unless it lands on the same project as the previous login. A service belongs to the project it was created in\n- `version_check` - When `true`, the CLI checks for a newer version on each invocation (in an interactive terminal) and prints a notice if one is available. Set to `false` to disable. Default: `true`.\n\n### Environment Variables\n\nEnvironment variables override configuration file values. All variables use the `TIGER_` prefix:\n\n- `TIGER_ANALYTICS` - Enable/disable analytics\n- `TIGER_COLOR` - Enable/disable colored output\n- `TIGER_CONFIG_DIR` - Path to configuration directory (default: `~/.config/tiger`)\n- `TIGER_DOCS_MCP` - Enable/disable docs MCP proxy\n- `TIGER_OUTPUT` - Output format: `json`, `yaml`, or `table`\n- `TIGER_PASSWORD_STORAGE` - Password storage method: `keyring`, `pgpass`, or `none`\n- `TIGER_READ_ONLY` - Which services this CLI may change: `all`, `prod`, or `off` (same aliases as `read_only`)\n- `TIGER_PUBLIC_KEY` - Public key to use for authentication (takes priority over stored credentials)\n- `TIGER_SECRET_KEY` - Secret key to use for authentication (takes priority over stored credentials)\n- `TIGER_SERVICE_ID` - Default service ID\n- `TIGER_VERSION_CHECK` - When `true`, the CLI checks for a newer version on each invocation (in an interactive terminal) and prints a notice if one is available; `false` to disable\n\n### Global Flags\n\nThese flags are available on all commands and take precedence over both environment variables and configuration file values:\n\n- `--analytics` - Enable/disable analytics\n- `--color` - Enable/disable colored output\n- `--config-dir <path>` - Path to configuration directory (default: `~/.config/tiger`)\n- `--password-storage <method>` - Password storage method: `keyring`, `pgpass`, or `none`\n- `--service-id <id>` - Specify service ID\n- `--skip-update-check` - Skip checking for updates on startup (default: `false`)\n- `-h, --help` - Show help information\n\n## Contributing\n\nWe welcome contributions! Here's how to get started:\n\n1. Fork the repository\n2. Create a feature branch\n3. Make your changes\n4. Add tests for new functionality\n5. Ensure all tests pass (`go test ./...`)\n6. Submit a pull request\n\nFor detailed development information, see [docs/development.md](docs/development.md).\n\n## License\n\nThis project is licensed under the Apache License 2.0 - see the [LICENSE](LICENSE) file for details.\n",
  "bytes": 14075,
  "sha": "b39c151159c842925e544d3e2bfb7f5eab0e38155963ac06b9dd355d8448063d",
  "repo_slug": "timescale/tiger-cli",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/mcp_io_github_timescale_tiger_cli_af658b20/readme"
}