Integration

CockroachDB integration

CockroachDB Cloud API for managing distributed SQL database clusters. Create, scale, and monitor clusters, manage SQL users and databases, configure backups and restores, set up networking with IP allowlists and private endpoints, manage egress rules, export logs and metrics to monitoring platforms like Datadog, CloudWatch, and Prometheus, manage maintenance windows, API keys, service accounts, billing, audit logs, and folders.

Connect CockroachDB How integrations work

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in CockroachDB.Built from the 89 CockroachDB tools below, on the connection you add once.

Common CockroachDB use cases

Revoke a compromised API key
Review monthly billing charges
Stop log export to reduce costs
Stop Prometheus metric scraping
Stop sending metrics to Datadog
Check a folder's parent and path
Audit who made changes to clusters
Plan a CockroachDB version upgrade
Stop sending metrics to CloudWatch
Browse backup history for a cluster

What you can do with CockroachDB

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Network, 18 operations

add_allowlist_entryAdd allowlist entryPOSTAdd an IP address to the allowlist for a CockroachDB cluster.
add_egress_ruleAdd egress rulePOSTAdd an egress rule to a CockroachDB cluster.
add_private_endpoint_connectionAdd private endpoint connectionPOSTAdd a private endpoint connection to a CockroachDB cluster.
add_private_endpoint_trusted_ownerAdd private endpoint trusted ownerPOSTAdd a private endpoint trusted owner to a CockroachDB cluster.
create_private_endpoint_servicesCreate private endpoint servicesPOSTCreate private endpoint services for a CockroachDB cluster.
delete_allowlist_entryDelete allowlist entryDELETERemove an IP allowlist entry from a CockroachDB cluster.
delete_egress_ruleDelete egress ruleDELETEDelete an egress rule from a CockroachDB cluster.
delete_private_endpoint_connectionDelete private endpoint connectionDELETEDelete a private endpoint connection from a CockroachDB cluster.
edit_egress_ruleEdit egress rulePATCHUpdate an existing egress rule on a CockroachDB cluster.
get_egress_ruleGet egress ruleGETGet details of a specific egress rule on a CockroachDB cluster.
list_allowlist_entriesList allowlist entriesGETList IP allowlist entries for a CockroachDB cluster.
list_egress_rulesList egress rulesGETList egress rules for a CockroachDB cluster.
list_private_endpoint_connectionsList private endpoint connectionsGETList private endpoint connections for a CockroachDB cluster.
list_private_endpoint_servicesList private endpoint servicesGETList private endpoint services for a CockroachDB cluster.
list_private_endpoint_trusted_ownersList private endpoint trusted ownersGETList private endpoint trusted owners for a CockroachDB cluster.
remove_private_endpoint_trusted_ownerRemove private endpoint trusted ownerDELETERemove a private endpoint trusted owner from a CockroachDB cluster.
set_egress_traffic_policySet egress traffic policyPOSTSet the egress traffic policy for a CockroachDB cluster.
update_allowlist_entryUpdate allowlist entryPATCHUpdate an IP allowlist entry on a CockroachDB cluster.

Metric export, 9 operations

delete_cloudwatch_metric_exportDelete cloudwatch metric exportDELETEDisable CloudWatch metric export for a CockroachDB cluster.
delete_datadog_metric_exportDelete datadog metric exportDELETEDisable Datadog metric export for a CockroachDB cluster.
delete_prometheus_metric_exportDelete prometheus metric exportDELETEDisable Prometheus metric export for a CockroachDB cluster.
enable_cloudwatch_metric_exportEnable cloudwatch metric exportPOSTEnable CloudWatch metric export for a CockroachDB cluster.
enable_datadog_metric_exportEnable datadog metric exportPOSTEnable Datadog metric export for a CockroachDB cluster.
enable_prometheus_metric_exportEnable prometheus metric exportPOSTEnable Prometheus metric export for a CockroachDB cluster.
get_cloudwatch_metric_export_infoGet cloudwatch metric export infoGETGet CloudWatch metric export configuration for a CockroachDB cluster.
get_datadog_metric_export_infoGet datadog metric export infoGETGet Datadog metric export configuration for a CockroachDB cluster.
get_prometheus_metric_export_infoGet prometheus metric export infoGETGet Prometheus metric export configuration for a CockroachDB cluster.

Cluster, 6 operations

create_clusterCreate clusterPOSTCreate and initialize a new CockroachDB cluster.
delete_clusterDelete clusterDELETEPermanently delete a CockroachDB cluster and all its data.
get_clusterGet clusterGETGet detailed information about a specific CockroachDB cluster.
get_connection_stringGet connection stringGETGet a formatted connection string for a CockroachDB cluster.
list_clustersList clustersGETList all CockroachDB clusters in the organization.
update_clusterUpdate clusterPATCHUpdate configuration of an existing CockroachDB cluster.

Folder, 6 operations

create_folderCreate folderPOSTCreate a new folder in the CockroachDB organization.
delete_folderDelete folderDELETEDelete a folder from the CockroachDB organization.
get_folderGet folderGETGet details of a specific folder in the CockroachDB organization.
list_folder_contentsList folder contentsGETList the contents of a folder in the CockroachDB organization.
list_foldersList foldersGETList folders in the CockroachDB organization.
update_folderUpdate folderPATCHUpdate a folder in the CockroachDB organization.

Api key, 5 operations

create_api_keyCreate api keyPOSTCreate a new API key for CockroachDB Cloud.
delete_api_keyDelete api keyDELETEDelete a CockroachDB API key.
get_api_keyGet api keyGETGet details of a specific CockroachDB API key.
list_api_keysList api keysGETList API keys for the CockroachDB organization.
update_api_keyUpdate api keyPATCHUpdate a CockroachDB API key.

Service account, 5 operations

create_service_accountCreate service accountPOSTCreate a new service account for CockroachDB Cloud.
delete_service_accountDelete service accountDELETEDelete a CockroachDB service account.
get_service_accountGet service accountGETGet details of a specific CockroachDB service account.
list_service_accountsList service accountsGETList service accounts for the CockroachDB organization.
update_service_accountUpdate service accountPATCHUpdate a CockroachDB service account.

Database, 4 operations

create_databaseCreate databasePOSTCreate a new database in a CockroachDB cluster.
delete_databaseDelete databaseDELETEDelete a database from a CockroachDB cluster.
edit_databaseEdit databasePATCHRename a database in a CockroachDB cluster.
list_databasesList databasesGETList all databases in a CockroachDB cluster.

Encryption, 4 operations

enable_cmek_specEnable cmek specPOSTEnable Customer Managed Encryption Keys for a CockroachDB cluster.
get_cmek_cluster_infoGet cmek cluster infoGETGet CMEK information for a CockroachDB cluster.
rotate_cmek_keyRotate cmek keyPUTRotate the CMEK key for a CockroachDB cluster.
update_cmek_configUpdate cmek configPATCHModify CMEK configuration for a CockroachDB cluster.

Role, 4 operations

add_user_to_roleAdd user to rolePOSTAssign a role to a user or service account in CockroachDB.
get_all_roles_for_userGet all roles for userGETGet all role grants for a specific user in CockroachDB.
list_role_grantsList role grantsGETList all role grants in the CockroachDB organization.
remove_user_from_roleRemove user from roleDELETERemove a role from a user or service account in CockroachDB.

Sql user, 4 operations

create_sql_userCreate sql userPOSTCreate a new SQL user on a CockroachDB cluster.
delete_sql_userDelete sql userDELETEDelete a SQL user from a CockroachDB cluster.
list_sql_usersList sql usersGETList all SQL users on a CockroachDB cluster.
update_sql_user_passwordUpdate sql user passwordPUTUpdate a SQL user's password on a CockroachDB cluster.

Backup, 3 operations

get_backup_configurationGet backup configurationGETGet the backup configuration for a CockroachDB cluster.
list_backupsList backupsGETList backups for a CockroachDB cluster.
update_backup_configurationUpdate backup configurationPATCHUpdate the backup configuration for a CockroachDB cluster.

Certificate, 3 operations

delete_client_ca_certDelete client ca certDELETEDelete the Client CA Certificate from a CockroachDB cluster.
get_client_ca_certGet client ca certGETGet the Client CA Certificate for a CockroachDB cluster.
set_client_ca_certSet client ca certPOSTSet the Client CA Certificate for a CockroachDB cluster.

Log export, 3 operations

delete_log_exportDelete log exportDELETEDisable log export for a CockroachDB cluster.
enable_log_exportEnable log exportPOSTEnable or update log export for a CockroachDB cluster.
get_log_export_infoGet log export infoGETGet the log export configuration for a CockroachDB cluster.

Maintenance, 3 operations

delete_maintenance_windowDelete maintenance windowDELETEDelete the maintenance window for a CockroachDB cluster.
get_maintenance_windowGet maintenance windowGETGet the maintenance window configuration for a CockroachDB cluster.
set_maintenance_windowSet maintenance windowPUTSet the maintenance window for a CockroachDB cluster.

Restore, 3 operations

create_restoreCreate restorePOSTCreate a restore job from a backup on a CockroachDB cluster.
get_restoreGet restoreGETGet the status and details of a CockroachDB restore job.
list_restoresList restoresGETList restore jobs for a CockroachDB cluster.

Version, 3 operations

get_cluster_version_deferralGet cluster version deferralGETGet the version upgrade deferral policy for a CockroachDB cluster.
list_major_cluster_versionsList major cluster versionsGETList available CockroachDB major versions.
set_cluster_version_deferralSet cluster version deferralPUTSet the version upgrade deferral policy for a CockroachDB cluster.

Billing, 2 operations

get_invoiceGet invoiceGETGet a specific invoice for the CockroachDB organization.
list_invoicesList invoicesGETList invoices for the CockroachDB organization.

Audit log, 1 operation

list_audit_logsList audit logsGETList audit log events for the CockroachDB organization.

Node, 1 operation

list_cluster_nodesList cluster nodesGETList all nodes in a CockroachDB cluster.

Organization, 1 operation

get_organization_infoGet organization infoGETGet information about the CockroachDB organization.

Region, 1 operation

list_available_regionsList available regionsGETList available cloud regions for new CockroachDB clusters.

Use CockroachDB from Claude Code, Cursor or Codex

Connect CockroachDB in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its CockroachDB operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect CockroachDB

Create your workspace
Sign up free. Nothing to install.
Connect CockroachDB once
Add your CockroachDB connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.

CockroachDB integration FAQ

What can you do with the CockroachDB integration?

LiveContext exposes 89 operations on CockroachDB, covering network, metric export, cluster and folder. Common uses include Revoke a compromised API key, Review monthly billing charges and Stop log export to reduce costs.