Borrowing it
Nothing to install: this file belongs to bpamiri/cockroachdb-mcp. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/bpamiri/cockroachdb-mcp/main/CLAUDE.mdgit clone --depth 1 https://github.com/bpamiri/cockroachdb-mcpWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/instructions/bpamiri/cockroachdb-mcp/claude-md)<a href="https://agentmods.dev/instructions/bpamiri/cockroachdb-mcp/claude-md"><img src="https://agentmods.dev/badge/instructions/bpamiri/cockroachdb-mcp/claude-md.svg" alt="Measured on agentmods" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00870 | $0.00870 |
| Opus 5 | $0.00435 | $0.00435 |
| Sonnet 5 | $0.00174 | $0.00174 |
| Haiku 4.5 | $0.00087 | $0.00087 |
Grade A, and why
cockroachdb-mcp CLAUDE.md scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 7d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 96 lines — stays where its author put it; the contents beside it link to each section on GitHub.
CLAUDE.md
This file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.
Project Overview
cockroachdb-mcp is a Python MCP (Model Context Protocol) server that enables AI assistants to interact with CockroachDB clusters. It uses psycopg (PostgreSQL driver) since CockroachDB is PostgreSQL-compatible, and provides tools for querying, CRUD operations, and cluster management.
Development Commands
# Install in development mode with dev dependencies
pip install -e ".[dev]"
# Run tests
pytest # All tests
pytest tests/test_connection.py # Single file
pytest --cov=cockroachdb_mcp --cov-report=html # With coverage
# Linting and type checking
ruff check .
ruff format .
mypy src/
Tech Stack
- Language: Python 3.10+
- MCP Framework:
mcp(FastMCP) - Database Driver:
psycopg(PostgreSQL-compatible) - Build System: hatchling with pyproject.toml
- Testing: pytest, pytest-cov, pytest-mock, pytest-asyncio
- Linting/Formatting: ruff
- Type Checking: mypy
- Settings: pydantic-settings (environment variable binding)
Architecture
src/cockroachdb_mcp/
├── server.py # FastMCP server entry point
├── connection.py # Connection management
├── config.py # Pydantic settings, environment config
├── tools/ # MCP tool implementations
│ ├── query.py # Query execution
│ ├── tables.py # Schema discovery
│ ├── crud.py # CRUD operations
│ ├── databases.py # Database management
│ ├── transaction.py # Transaction management
│ ├── cluster.py # Cluster operations
│ ├── export.py # Data export
│ └── knowledge.py # Knowledge persistence
├── auth/ # OAuth authentication
│ ├── provider.py # OAuth provider
│ ├── storage.py # Token storage
│ └── idp/ # Identity provider adapters
├── resources/ # MCP resources
│ ├── knowledge.py # Knowledge resource
│ ├── syntax_help.py # SQL reference
│ └── examples.py # Example queries
└── utils/
├── safety.py # Query validation
├── watchdog.py # Connection watchdog
├── knowledge.py # Knowledge file manager
└── audit.py # Audit logging
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 7d ago First seen · 96 lines · 870 tokens per session scan A 6ff057929bbf
cockroachdb-mcp CLAUDE.md is an instructions file published in the GitHub repository bpamiri/cockroachdb-mcp (0 stars, last pushed 8mo ago), licensed Apache-2.0. It adds 870 tokens to every session, about $0.0043 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
Other instructions, from other repositories
codex AGENTS.md
AGENTS.md instructions for openai/codex, covering rust/codex-rs, the codex-core crate, code review rules, crate api surface and model visible context.
vscode buildNext.instructions.md
Working notes and architecture documentation for the new esbuild-based build system in build/next. Use when making changes to the new build pipeline (transpile/bundle commands, NLS plugin, source-map handling, resource copying, or self-hosting watch tasks).
next.js AGENTS.md
AGENTS.md instructions for vercel/next.js, covering next.js development guide, codebase structure, monorepo overview, core package: packages/next and other important packages.
langchain AGENTS.md
AGENTS.md instructions for langchain-ai/langchain, covering global development guidelines for the langchain monorepo, corridor security analysis, project architecture and context, monorepo structure and development tools & commands.
vscode oss-third-party-notices.instructions.md
Instructions for microsoft/vscode, covering vs code oss third-party-notices pipeline, architecture, pipeline flow in ci, applying the notice (cutover) and fallback chain (never fail the build).
spec-kit AGENTS.md
AGENTS.md instructions for github/spec-kit, covering agents.md, about spec kit and specify, quickstart — add a new integration in 5 steps, integration architecture and integrationmanifest — file tracking.