Same door for humans and AI. No gatekeeper.Register →
Explorer/MCP/smithery/clickhouse

ClickHouse

REMOTE
smithery/clickhouse

Query ClickHouse Cloud — run SQL, list databases and tables, explore services and backups, inspect usage, run ClickPipes.

○ Remote (HTTP) Server
This server runs on the internet and communicates over HTTP. It does not have direct access to your local filesystem or environment variables.
Tools
13
Indexed
1d ago
Transport
Remote / HTTP
Liveness
● Live
Uptime
100%based on 1 checks
Avg response
283ms
← older · newer →
Security Scan
Security scan pending — this server has not yet been analyzed.
Risk Surface
Risk surface analysis pending — tool annotation scanning is coming soon.
Publisher Verification
Not yet verified by the Official MCP Registry.
Endpoint
https://clickhouse.run.tools
Tools (13)
get_clickpipe
Returns the specified ClickPipe.
get_organizations
Retrieves all accessible ClickHouse Cloud organizations.
run_select_query
Executes a SELECT query against a ClickHouse service. Runs a read-only SELECT query on the specified ClickHouse service via the Query API endpoint. This function provides direct access to database content through SQL queries while ensuring that only read operations are permitted.
list_databases
Retrieves all databases available in a ClickHouse service.
list_tables
Retrieves a comprehensive list of tables in a ClickHouse database, including columns.
get_services_list
Retrieves all services in a ClickHouse Cloud organization.
get_organization_details
Returns details of a single organization. The auth key must belong to the organization.
get_service_details
Returns a service that belongs to the organization.
list_clickpipes
Retrieves all ClickPipes configured for a specific service.
list_service_backups
Returns a list of all backups for the service. The most recent backups comes first in the list.
get_organization_cost
Retrieves billing and usage cost data for a ClickHouse Cloud organization. Returns a grand total and a list of daily, per-entity organization usage cost records for the organization in the queried time period (maximum 31 days).
get_service_backup_details
Returns a single backup info.
get_service_backup_configuration
Returns the service backup configuration.
Is this your server?
Create a free RNWY account to connect your on-chain identity to this server. MCP server claiming is coming — register now and you'll be first in line.
Create your account →
More from smithery
Jam
Capture and report bugs with automatic screen recordings and environment details. Create, view, and manage bug reports with full context.
wcgw
Shell and coding agent on Claude and ChatGPT.
Minecraft
A Model Context Protocol (MCP) integration for Minecraft enabling AI assistants to interact with a Minecraft server.
NMAP Server
Perform network scanning operations using NMAP.
Boldsign
Send, sign, and manage legally binding documents. Track signature status, set reminders, and automate document workflows.
Octagon
AI agents for financial research. Query SEC filings, analyze company data, and retrieve market intelligence.
Similar servers
HiveAgent
HiveAgent is the only MCP server built for the agentic economy — 1,000+ tools across 45+ verticals in a single installation - unprecedented. PAYMENT RAILS (every one that exists): Visa Intelligent Commerce Connect · Mastercard Agent Pay · Stripe MPP · x402 (Coinbase) · BVNK Enterprise · Circle CPN · Circle Arc L1 · OpenAI ACP · Google UCP · PayPal ACP · HandlPay · Coinbase CDP · USDC streaming · Stablecoin yield (4-12% APY) · Fiat offramp AGENT PROTOCOLS: Google A2A · AP2 (ERC-4337) · QVAC/Tether (integrated same day as launch) · MCP-native AGENT ECONOMY: Agent marketplace (buy/sell services) · Outcome-based billing · Pay-per-inference model payments · Multi-agent orchestration · Agent credit (USDC microloans) · Agent insurance (up to $1M) · DeFi yield optimizer · Cross-chain bridge · Tokenized real-world assets · Data marketplace · Smart escrow · Cross-border payments (180+ countries) AGENT INFRASTRUCTURE: Decentralized identity (DID, Verifiable Credentials, ZK proofs) · Agent reputation scoring · Deployment manager + SLA tracking · Agent analytics + benchmarking · LLM router (cheapest model per task) · Tax/accounting (US/EU/UK) · Regulatory compliance (GDPR, EU AI Act, MiCA) SECURITY: Real-time prompt injection scanning · Memory integrity (tamper detection) · Circuit breaker (instant quarantine) · Human-in-the-loop gate · Behavioral anomaly detection · Agent identity verification 40+ INDUSTRY VERTICALS: Insurance · Legal · Healthcare · Real estate · Construction · Supply chain · Agriculture · Energy · Fleet · HR · DeFi · NFT · Prediction markets · Travel · Media · Cybersecurity · Government · Education · and more 95/100 Smithery score. All green. Render auto-deploys on every push.
ifrCoworker by SPOCONT
ifrCoworker — IFRS MCP is the first Model Context Protocol server for International Financial Reporting Standards. It lets any MCP-capable agent (Claude Desktop, Claude Code, Cursor, Cline, etc.) perform authoritative IFRS/IAS calculations — complete with journal entries, disclosures, paragraph references and audit trail. 🎯 Recommended usage: agentic period-end close via MCP A small company's complete annual financial reporting (statement of financial position, statement of comprehensive income, OCI, statement of cash flows, all required disclosures) can be processed within a single STANDARD subscription when used through an MCP-capable agent with the ifrs_period_end_batch tool. The workflow is built in: the agent reads the static ifrs://reference/accounting-policy-choices resource, confirms the entity-wide accounting policy choices with the user, assembles the policy block, then submits all positions in one batch call — and gets back a consolidated trial balance grouped by XBRL section, every journal entry tagged to its ESEF taxonomy element, all required disclosures, and a complete audit trail. We strongly recommend this workflow for everyday financial reporting; it is the most cost-effective way to use the engine. What makes it different: • 27 IFRS/IAS standards covered end-to-end: IAS 2, 7, 10, 12, 16, 19, 20, 21, 23, 28, 33, 36, 37, 38, 40, 41, IFRS 2, 3, 5, 6, 8, 9, 10, 11, 13, 15, 16. Each with full field-level schemas and paragraph references; every entity-level accounting policy choice (cost vs revaluation, FIFO vs weighted average, INDIRECT vs DIRECT cash flow, byClass overrides per IAS 16.36 / IAS 2.25) and every IFRS rebuttable presumption (futureTaxableProfitProbable, sicrPresumptionRebutted, extensionPresumptionRebutted, etc.) is required upfront — no silent defaults, no hidden judgement. • Period-end batch (ifrs_period_end_batch): works for ANY reporting period — annual, quarterly, monthly. The tool validates a complete entity-wide accountingPolicy block first (functionalCurrency, presentationCurrency, reportingDate plus per-standard policy blocks like ias16.measurementModel with optional byClass per asset class) and rejects with a hard error if anything is missing. Returns per-item results, consolidated journal entries, and a structured trial balance grouped by XBRL section (BalanceSheet, IncomeStatement, OCI, Equity, Unclassified) with per-account debit/credit/net totals and ESEF tags. • Direct P&L / equity entries (IAS 1 utility): wages, services, dividends, share premium, retained-earnings transfers, OCI revaluation, opening balances, prior-period corrections, IAS 10 adjusting entries — every routine transaction that has no dedicated IFRS measurement model can still be posted with full XBRL tagging, so the trial balance is complete. • PDF ingestion via Google Document AI: ifrs_ingest_document extracts structured data from invoices, lease agreements, bond indentures and contracts. ifrs_propose_mapping routes it to the right IFRS standard and proposes an input. The user reviews, then ifrs_calculate posts the journal entry. The full docu-scan → bookkeeping pipeline in one MCP server. • Automatic cross-standard redirects: provide taxBase + currentTaxRate anywhere → IAS 12 deferred tax fires automatically. Provide transactionCurrency that differs from functionalCurrency → IAS 21 FX overlay fires (and rejects upfront with a hard error if you forgot the closing rate on a monetary item — no silent failures). Provide subsequentEventDate → IAS 10 overlay applies. Provide a specific borrowing for a qualifying asset → IAS 23 capitalisation fires. No manual chaining. • Validate-then-calculate everywhere: every calculate call runs validate first; missing or invalid input is rejected with a clear, actionable error message before any credit is consumed. • Consolidation: IFRS 10 multi-entity consolidation with full W1–W5 working papers (W1 Net Assets, W2 Goodwill, W3 Group Retained Earnings, W4 NCI, W5 Group OCI). Each subsidiary carries its own NCI measurement basis (FAIR_VALUE or PROPORTIONATE_SHARE), FV adjustments, intercompany items. • Held for sale (IFRS 5): freezes depreciation, amortisation and equity method across IAS 16, 28 and 38 with a single classifiedAsHeldForSaleDate flag. All 7 IFRS 5 recognition criteria validated. • Plain-language discovery: ifrs_what_standard lets users describe a scenario in natural language ("customer went bankrupt", "signed a 10-year lease", "FX-denominated receivable", "December wages") and returns the top 3 matching standards with copy-paste-ready inputs. • Static MCP resources: ifrs://reference/accounting-policy-choices is the menu the agent reads before batch — every entity-level policy choice with its IFRS paragraph reference and allowed values. ifrs://examples/techservices-2025 is a complete sample period-end close (53 items covering all standards in scope, accounting policy block, year-end FX rates) to use as a template. • Deterministic, auditable, no hallucination: pure calculation engine; every number is traceable; every line cites the IAS/IFRS paragraph; every applied rebuttable presumption is echoed for the audittrail. Licensing • STANDARD — daily financial reporting workload. Sized so that a small company's full period-end close (presented in batch mode via an MCP agent) fits within one subscription. Recommended for owner-managed entities, small CFO offices, freelance accountants, audit reviewers. Current pricing and credit allocation are visible only at https://ifr.spocont.com (also via GET /api/ifrs/access/status). Get a free trial at POST /api/ifrs/access/purchase. • FULL — for large companies and heavy-API users (Big-4 audit, group consolidation, automated platforms). Includes high call volumes, full OpenAPI access, full per-standard policy customisation, and bespoke onboarding. By quotation only: contact [email protected] or click "Send message" on https://ifr.spocont.com. Who is it for? • AI agent builders who want accounting intelligence without training domain-specific models • Accountants and CFOs who run AI assistants for first-pass bookkeeping and IFRS compliance • Small companies running their entire annual close through one MCP agent + STANDARD subscription • Large companies and audit firms needing a deterministic IFRS reference engine — FULL license by quotation • DipIFR / ACCA students studying for the exam — use it to double-check mock calculations Access: free trial at POST https://ifr.spocont.com/api/ifrs/access/purchase. Paid tiers via Revolut. STANDARD subscription self-serve from the same endpoint; FULL by quotation. built by SPOCONT
the402.ai
AI agent service marketplace — browse, purchase, and manage services via x402 micropayments (USDC on Base)
coverage
PixelLab
Generate animated pixel art characters, tilesets, and object directly from your AI coding assistant!
CryptoGuard
Protect cryptocurrency investments by validating trades and scanning for potential rug pulls. Identify anomalous market behavior and high-risk trading pairs before executing transactions. Ensure safer trading through real-time risk assessments and liquidity analysis.
Indexed from Smithery · Updates nightly
View on Smithery →