MCP servers · CockroachDB · MCP server
Connect Codex CLI to CockroachDB
One line gives Codex CLI your CockroachDB account as tools: 7 endpoints, clusters, called with your own connection. No key in the prompt, a receipt for every call, revoke Codex CLI's access alone any time.
Three steps
- Create a free 0n3 account and connect CockroachDB. Paste a key or sign in; it lands in your vault, encrypted.
- Install 0n3 into Codex CLI. OpenAI's terminal agent reads 0n3 over Streamable HTTP with a token from your environment.
- Ask Codex CLI: whoami. Then: "List clusters in CockroachDB".
Put the token in your environment
export ON3_TOKEN="<your 0n token>"
Add it to your shell profile so Codex finds it next time.
The line above carries a placeholder; 0n3.app/install mints a real key named for Codex CLI and fills it in.
What Codex CLI can then do in CockroachDB
Clusters · Manage clusters7
List clusters
GET /clustersCreate a cluster
POST /clustersGet a cluster
GET /clusters/{cluster_id}Delete a cluster
DELETE /clusters/{cluster_id}List sql users
GET /clusters/{cluster_id}/sql-usersCreate a sql user
POST /clusters/{cluster_id}/sql-usersList databases
GET /clusters/{cluster_id}/databasesCockroachDB in other AI clients
Claude Code + CockroachDBMCP server + skillClaude (desktop & claude.ai) + CockroachDBconnectorChatGPT + CockroachDBconnector · GPT actionGemini CLI + CockroachDBMCP serverCursor + CockroachDBMCP serverVS Code (Copilot) + CockroachDBMCP serverWindsurf + CockroachDBMCP server
