KosmoKrator

data

CockroachDB MCP Integration for OpenAI Agents SDK

Connect CockroachDB to OpenAI Agents SDK through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

7 functions 6 read 1 write Bearer token auth
Submit CockroachDB feedback View package source

Connect CockroachDB to OpenAI Agents SDK

Attach KosmoKrator integration tools to OpenAI Agents SDK workflows through a local MCP gateway.

Start the KosmoKrator MCP gateway locally and point the OpenAI Agents SDK MCP tool at that process or wrapper. The gateway is local, scoped to this integration, and starts with --write=deny so OpenAI Agents can inspect read-capable tools without receiving write access by default.

CockroachDB MCP Config for OpenAI Agents SDK

Use headless JSON commands for CI-style execution and MCP for agent tool discovery.

{
  "mcpServers": {
    "kosmokrator-cockroachdb": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=cockroachdb",
        "--write=deny"
      ]
    }
  }
}

Run the Gateway Manually

kosmokrator mcp:serve --integration=cockroachdb --write=deny

Why Use KosmoKrator Here

Scoped tools

Expose only CockroachDB instead of a broad multi-service tool list.

Local credentials

Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.

Write policy

Start read-only, then opt into ask or allow for trusted workspaces.

CockroachDB Tools Visible to OpenAI Agents

OpenAI Agents sees stable MCP tool names generated from the CockroachDB integration catalog.

MCP toolSource functionTypeDescription
integration__cockroachdb__cockroachdb_list_clusters cockroachdb.cockroachdb_list_clusters Read List all CockroachDB clusters in the organization. Returns cluster IDs, names, status, cloud provider, and regions.
integration__cockroachdb__cockroachdb_get_cluster cockroachdb.cockroachdb_get_cluster Read Get details for a specific CockroachDB cluster by ID. Returns full cluster information including configuration, nodes, and connection strings.
integration__cockroachdb__cockroachdb_create_cluster cockroachdb.cockroachdb_create_cluster Write Create a new CockroachDB cluster. Requires a name, cloud provider, and region configuration.
integration__cockroachdb__cockroachdb_list_databases cockroachdb.cockroachdb_list_databases Read List all databases in a CockroachDB cluster. Returns database names, sizes, and table counts.
integration__cockroachdb__cockroachdb_get_database cockroachdb.cockroachdb_get_database Read Get details for a specific database in a CockroachDB cluster. Returns table list, sizes, and configuration.
integration__cockroachdb__cockroachdb_list_users cockroachdb.cockroachdb_list_users Read List all SQL users in a CockroachDB cluster. Returns usernames and privileges.
integration__cockroachdb__cockroachdb_get_current_user cockroachdb.cockroachdb_get_current_user Read Get information about the current authenticated CockroachDB Cloud user, including email, name, and organization role.

Related CockroachDB Pages

CockroachDB CLIUse direct JSON commands instead of MCP discovery. CockroachDB MCPFull gateway reference and MCP tool names. KosmoKrator for OpenAI AgentsClient-level gateway setup.