ClickHouse

Fair

Agent Native Score

Free TierAPI Key Auth

ClickHouse is an open-source column-oriented OLAP database management system designed for fast analytics on large volumes of data. It provides SQL query capabilities and is optimized for real-time data analysis.

Categories: Database · Analytics · Data Warehouse

#46 of 69 in Database · #72 of 117 in Analytics · #2 of 4 in Data Warehouse

Checklist Breakdown

12 of 33 checks passed. 14 unscored.

Discovery 50%

Can an agent find and understand this tool without a web search?

✗ Published OpenAPI/Swagger spec

✗ Has llms.txt or llms-full.txt

✗ Has an MCP server (official or well-maintained)

✗ MCP server listed in a public registry

✓ API reference docs are publicly accessible

✓ Docs include runnable code examples

✓ Has a public changelog or release notes

✓ Has a public status page

Auth & Onboarding 50%

Can an agent create an account and get credentials without human intervention?

✗ Signup does not require CAPTCHA

✗ Signup does not require phone verification

✓ Supports API key auth (not only OAuth)

✗ API key obtainable without manual approval

✓ No mandatory billing info to start

✓ Can sign up without creating an organization

Pricing 100%

Can an agent operate autonomously without upfront payment or contracts?

✓ Has a free tier

✓ Usage-based pricing available

✓ No minimum contract or commitment

✓ Pricing page is public (no 'contact sales')

✓ Free tier sufficient for testing (not just a trial)

Agent Tooling Not yet scored

How well does the API work for non-human consumers?

— SDK available in 2+ languages

— Structured error responses (JSON with error codes)

— Idempotency support on write endpoints

— Pagination on list endpoints

— Webhook/event support

— Sandbox or test mode available

— Rate limit headers in responses

— Consistent REST resource naming

Reliability Not yet scored

Does the tool fail gracefully when an agent makes a mistake?

— Meaningful error messages (not just 500)

— 429 responses include Retry-After header

— Documented uptime SLA (99.9%+)

— Graceful degradation under rate limits

— Request IDs in responses for debugging

— API versioning supported

Reviewer Notes

ClickHouse has strong agent tooling with excellent SQL support, native drivers in multiple languages, and predictable database behavior. However, it lacks modern API-first discovery tools—no MCP server, OpenAPI spec, or llms.txt—making initial discovery and configuration harder for agents. Account creation requires manual setup with no programmatic signup flow. The platform is highly reliable for data operations once connected, but pricing complexity (self-hosted free vs. managed cloud) and lack of built-in agent orchestration patterns limit autonomous adoption.

ClickHouse

Let your agents find tools like ClickHouse