# CockroachDB Cloud MCP for AI Agents AI Agent Connect

> CockroachDB Cloud lets you manage your distributed SQL clusters using your AI agent. You can track cluster health, monitor individual nodes, audit management operations, and manage network allowlists or encryption keys without leaving your chat interface. It bridges the gap between your cloud database infrastructure and your daily workflow, making it easy to keep your data accessible and secure.

## Overview
- **Category:** fort-knox
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_lXJMfvTxkQ8roFLANT9KKH5ZXboI6KmNc6teoSqs/ai-agent-connect
- **Tags:** distributed-sql, cluster-management, high-availability, scalability, database-monitoring, cloud-native

## Description

CockroachDB Cloud lets you manage your distributed SQL clusters using your AI agent. Managing a distributed database usually involves a lot of tab-switching and context jumping. You often have to log into a separate cloud console just to check if a node is healthy, verify a regional distribution, or see who changed a network rule last night. This Connector changes that by bringing your infrastructure directly into your chat interface. Instead of navigating nested menus and clicking through various dashboards, you can just ask your agent to show you the status of your production cluster or find out which encryption keys are being used. It's a way to handle the heavy lifting of database operations through plain conversation. When you use this through the Vinkius catalog, you're essentially giving your agent a set of hands to interact with your database backend. You can audit scaling events, verify cloud provider availability, and manage security rules on the fly. It's about getting the information you need without the friction of the traditional console. It turns a multi-click navigation process into a simple, fluid conversation, letting you stay in your flow state while keeping your infrastructure organized. Whether you're checking on a cluster upgrade or verifying a network allowlist, you get the answers you need instantly without the overhead of a web portal.

## Tools

### get_cluster_cloud_details
Get specific details for a single cluster, including provider and region.

### get_my_cockroach_profile
Retrieve information about your authenticated user and organization.

### list_network_allowlist
View the network allowlist rules for a specific cluster to manage connectivity.

### list_encryption_keys
See the Customer Managed Keys used for your cluster's data encryption.

### list_supported_cloud_providers
Check which cloud providers are supported by CockroachDB Cloud.

### list_cockroach_clusters
List all of your CockroachDB Cloud clusters in one go.

### list_cluster_nodes
List every node within a specific cluster to check for health issues.

### list_cluster_operations
Review recent management tasks like scaling or upgrades for a cluster.

## Prompt Examples

**Prompt:** 
```
List all my clusters.
```

**Response:** 
```
Retrieving your database clusters... I found 2 clusters: 'Production-Main' (AWS, us-east-1) and 'Dev-Sandbox' (GCP, europe-west1). Both are currently in 'RUNNING' status.
```

**Prompt:** 
```
Show me the network allowlist for the 'Production-Main' cluster.
```

**Response:** 
```
Checking network allowlist... The Production-Main cluster has 3 rules: 'Office VPN' (1.2.3.4/32), 'App Server Fleet' (10.0.0.0/16), and 'Admin Backup' (5.6.7.8/32).
```

**Prompt:** 
```
What was the result of the last operation on cluster 'Dev-Sandbox'?
```

**Response:** 
```
Retrieving last operation... The most recent task was 'CLUSTER_UPDATE' (minor version upgrade) completed successfully two hours ago. It took approximately 15 minutes.
```

## Capabilities

### List all clusters
See every CockroachDB Cloud cluster in your account at a glance.

### Check node health
Get the current status and details for specific nodes in your clusters.

### Audit cluster history
Review recent management operations like scaling or upgrades.

### Manage network rules
View and monitor the allowlist rules for your database connectivity.

### Inspect encryption keys
See which Customer Managed Keys are protecting your cluster data.

### Get user profile info
Retrieve information about your authenticated organization and user profile.

### View cloud providers
Check which cloud platforms are currently supported by CockroachDB Cloud.

## Use Cases

### Incident Response
A node goes down; the DBA asks the agent to list all nodes and check the status of the production cluster.

### Security Audit
A security engineer needs to verify the allowlist for the 'Dev' cluster to ensure no unauthorized IPs are listed.

### Capacity Planning
A cloud engineer asks the agent to list recent scaling operations to see how the database has handled traffic.

### Onboarding
A new team member asks the agent for a summary of all available clusters and their current cloud providers.

## Benefits

- Faster troubleshooting: Use list_cluster_nodes to quickly identify failing nodes without logging into a web portal.
- Easier security audits: View your list_network_allowlist rules instantly to ensure only the right IPs have access to your database.
- Better change tracking: Use list_cluster_operations to see exactly when scaling or upgrades happened to keep a clear history of your infrastructure changes.
- Simplified key management: Access list_encryption_keys to manage your Customer Managed Keys without navigating complex cloud menus.
- Instant account context: Use get_my_cockroach_profile to keep your agent aware of your organization's details and your authenticated user profile.
- Quick regional checks: Use get_cluster_cloud_details to verify provider and region info across all your clusters to maintain a clear global overview.

## How It Works

The bottom line is you get a conversational interface for your entire distributed SQL infrastructure.

1. Subscribe to the CockroachDB Cloud MCP on Vinkius.
2. Enter your CockroachDB Cloud API Secret Key in your AI client.
3. Ask your agent to perform tasks like listing clusters or checking node status.

## Frequently Asked Questions

**Can I use the CockroachDB Cloud MCP to run SQL queries?**
No, this Connector is for managing your database infrastructure like clusters and nodes. You won't be able to run queries against your data tables with it.

**How do I connect my CockroachDB Cloud account to my AI agent?**
You'll need to subscribe to the Connector on Vinkius and provide your CockroachDB Cloud API Secret Key in your AI client's settings.

**Can I see which nodes are failing in my cluster?**
Yes, you can ask your agent to list the nodes for a specific cluster to see their current health and status.

**Does this Connector help with database security?**
It lets you view network allowlist rules and Customer Managed Keys, which are essential for auditing your cluster's security posture.

**Can I see a history of recent scaling events?**
Yes, you can ask the agent to list the recent management operations for any cluster to see past scaling or upgrade tasks.

**Is this Connector compatible with Cursor or Claude?**
Yes, it works with any MCP-compatible client, including Claude, Cursor, Windsurf, and VS Code.

**Can I see the status of all nodes in a cluster through the agent?**
Yes! Use the `list_cluster_nodes` tool with the unique cluster ID. The agent will return a list of all nodes, their IP addresses, and their current health/operational state.

**How do I check for recent scaling or upgrade events on my database?**
Use the `list_cluster_operations` tool. Your agent will fetch the management log for the cluster, showing you recent tasks, their progress, and whether they were successful.

**Where do I find my CockroachDB Cloud API Secret Key?**
Log in to the CockroachDB Cloud Console, navigate to **Access Management**, and select **API Keys**. You can generate and copy a new Secret Key from that section.