Can I use CockroachDB as a CLI?

Yes. KosmoKrator exposes a CockroachDB CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose CockroachDB through MCP?

Yes. The KosmoKrator MCP gateway can expose selected CockroachDB tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are CockroachDB credentials stored?

CockroachDB credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for CockroachDB MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

data

CockroachDB MCP, CLI, and Lua Integration for AI Agents

CockroachDB integration docs for AI agents: MCP gateway setup, CockroachDB CLI commands, Lua API reference, credentials, and function schemas.

7 functions 6 read 1 write Bearer token auth

Submit CockroachDB feedback View package source

CockroachDB for agents

Credentials can be configured manually in web or CLI hosts.

Use this integration from Lua code mode, the headless integrations CLI, or the KosmoKrator MCP gateway. The same package metadata powers all three surfaces.

Machine-Readable Metadata

integration_slug: cockroachdb
route_slug: cockroachdb
package: cockroachdb
auth_strategy: bearer_token Bearer token
cli_setup_supported: true
cli_runtime_supported: true
mcp_gateway_supported: true
lua_supported: true
supports_multi_account: true

Quick Links

Lua APIAgent-facing namespace and function reference. CockroachDB CLIHeadless setup and direct function calls. CockroachDB MCPMCP gateway setup for external clients. Submit feedbackReport missing tools, auth problems, wrong docs, or runtime issues. ContributeAdd tools or improve metadata in the integrations repo.

CockroachDB MCP Client Matrix

Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for CockroachDB.

CockroachDB CLI Matrix

Use these pages for direct CockroachDB CLI workflows in scripts, CI, cron, and agent wrappers.

CI CockroachDB CLI for CI. Cron Jobs CockroachDB CLI for cron jobs. Shell Scripts CockroachDB CLI for shell scripts. Headless Automation CockroachDB CLI for headless automation. Coding Agents CockroachDB CLI for coding agents.

Function Catalog

Function	Type	Parameters	Description
`cockroachdb.cockroachdb_list_clusters`	Read `read`	0	List all CockroachDB clusters in the organization. Returns cluster IDs, names, status, cloud provider, and regions.
`cockroachdb.cockroachdb_get_cluster`	Read `read`	1	Get details for a specific CockroachDB cluster by ID. Returns full cluster information including configuration, nodes, and connection strings.
`cockroachdb.cockroachdb_create_cluster`	Write `write`	6	Create a new CockroachDB cluster. Requires a name, cloud provider, and region configuration.
`cockroachdb.cockroachdb_list_databases`	Read `read`	1	List all databases in a CockroachDB cluster. Returns database names, sizes, and table counts.
`cockroachdb.cockroachdb_get_database`	Read `read`	2	Get details for a specific database in a CockroachDB cluster. Returns table list, sizes, and configuration.
`cockroachdb.cockroachdb_list_users`	Read `read`	1	List all SQL users in a CockroachDB cluster. Returns usernames and privileges.
`cockroachdb.cockroachdb_get_current_user`	Read `read`	0	Get information about the current authenticated CockroachDB Cloud user, including email, name, and organization role.