Skip to content

Latest commit

Β 

History

History
44 lines (41 loc) Β· 13.3 KB

File metadata and controls

44 lines (41 loc) Β· 13.3 KB

$MCP_LONG exposes the following MCP tools to your AI Assistant:

Command Parameter Required Description
service_list - - Returns a list of the $SERVICE_SHORTs in the current $PROJECT_SHORT.
service_get - - Returns detailed information about a $SERVICE_SHORT.
service_id βœ“ The unique identifier of the $SERVICE_SHORT (10-character alphanumeric string).
with_password - Set to true to include the password in the response and connection string.
WARNING: never do this unless the user explicitly requests the password.
service_create - - Create a new $SERVICE_SHORT in $CLOUD_LONG.
WARNING: creates billable resources.
name - Set the human-readable name of up to 128 characters for this $SERVICE_SHORT.
addons - Set the array of addons to enable for the $SERVICE_SHORT. Options:
  • time-series: enables $TIMESCALE_DB
  • ai: enables the AI and vector extensions
Set an empty array for $PG-only.
region - Set the AWS region to deploy this $SERVICE_SHORT in.
cpu_memory - CPU and memory allocation combination.
Available configurations are:
  • shared/shared
  • 0.5 CPU/2 GB
  • 1 CPU/4 GB
  • 2 CPU/8 GB
  • 4 CPU/16 GB
  • 8 CPU/32 GB
  • 16 CPU/64 GB
  • 32 CPU/128 GB
replicas - Set the number of high-availability replicas for fault tolerance.
wait - Set to true to wait for the $SERVICE_SHORT to be fully ready before returning.
timeout_minutes - Set the timeout in minutes to wait for $SERVICE_SHORT to be ready. Only used when wait=true. Default: 30 minutes
set_default - By default, the new $SERVICE_SHORT is the default for following commands in $CLI_SHORT. Set to false to keep the previous $SERVICE_SHORT as the default.
with_password - Set to true to include the password for this $SERVICE_SHORT in response and connection string.
WARNING: never set to true unless user explicitly requests the password.
service_fork - - Fork an existing $SERVICE_SHORT to create a new independent copy.
WARNING: creates billable resources.
service_id βœ“ The unique identifier of the $SERVICE_SHORT to fork (10-character alphanumeric string).
fork_strategy βœ“ Fork strategy:
  • NOW: fork at the current database state
  • LAST_SNAPSHOT:fork at last existing snapshot. This is the faster option
  • PITR: create a point-in-time recovery. You must also set the target_time parameter for PITR forks.
target_time - Set the target time for a PIRT fork_strategy in RFC3339 format. For example 2025-01-15T10:30:00Z).
name - Set the human-readable name for the forked $SERVICE_SHORT. Defaults to {source-service-name}-fork.
cpu_memory - CPU and memory allocation combination. Inherits from source $SERVICE_SHORT if not specified.
Available configurations are:
  • shared/shared
  • 0.5 CPU/2 GB
  • 1 CPU/4 GB
  • 2 CPU/8 GB
  • 4 CPU/16 GB
  • 8 CPU/32 GB
  • 16 CPU/64 GB
  • 32 CPU/128 GB
wait - Set to true to wait for the forked $SERVICE_SHORT to be fully ready before returning. Default: false.
timeout_minutes - Set the timeout in minutes to wait for forked $SERVICE_SHORT to be ready. Only used when wait=true. Default: 30 minutes
set_default - By default, the forked $SERVICE_SHORT is set as the default for following commands in $CLI_SHORT. Set to false to keep the previous $SERVICE_SHORT as the default.
with_password - Set to true to include the password for the forked $SERVICE_SHORT in response and connection string.
WARNING: never set to true unless user explicitly requests the password.
service_update_password - - Update the password for the tsdbadmin for this $SERVICE_SHORT. The password change takes effect immediately and may terminate existing connections.
service_id βœ“ The unique identifier of the $SERVICE_SHORT you want to update the password for.
password βœ“ The new password for the tsdbadmin user.
db_execute_query - - Execute a single SQL query against a $SERVICE_SHORT. This command returns column metadata, result rows, affected row count, and execution time. Multi-statement queries are not supported.
WARNING: can execute destructive SQL including INSERT, UPDATE, DELETE, and DDL commands.
service_id βœ“ The unique identifier of the $SERVICE_SHORT. Use tiger_service_list to find $SERVICE_SHORT IDs.
query βœ“ The SQL query to execute. Single statement queries are supported.
parameters - Query parameters for parameterized queries. Values are substituted for the $n placeholders in the query.
timeout_seconds - The query timeout in seconds. Default: 30.
role - The $SERVICE_SHORT role/username to connect as. Default: tsdbadmin.
pooled - Use connection pooling. This is only available if you have already enabled it for the $SERVICE_SHORT. Default: false.