--- title: TKCat meets LLMs: an MCP server for well-documented... description: TKCat 1.3.0 adds a read-only MCP server that lets AI assistants query modeled databases. The server comes in a local stdio form (chTKCat_mcp_server) and a... canonical: https://daily.dev/posts/tkcat-meets-llms-an-mcp-server-for-well-documented-knowledge-resources-0abbyldwg twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: TKCat meets LLMs: an MCP server for well-documented knowledge resources | daily.dev og:description: TKCat 1.3.0 adds a read-only MCP server that lets AI assistants query modeled databases. The server comes in a local stdio form (chTKCat_mcp_server) and a... og:url: https://daily.dev/posts/tkcat-meets-llms-an-mcp-server-for-well-documented-knowledge-resources-0abbyldwg og:image: https://api.daily.dev/og/posts/0aBbYLdWG.png og:image:alt: TKCat meets LLMs: an MCP server for well-documented knowledge resources og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # TKCat meets LLMs: an MCP server for well-documented knowledge resources **[R-bloggers](https://daily.dev/sources/rbloggers)** · 5 min read · 0 upvotes · 0 comments ## Summary TKCat 1.3.0 adds a read-only MCP server that lets AI assistants query modeled databases. The server comes in a local stdio form (chTKCat_mcp_server) and a remote Streamable HTTP form (chTKCat_mcp_http_server) that runs next to a ClickHouse-backed chTKCat instance. Tools include list_mdbs, search_tkcat, describe_mdb, describe_tables, preview_table and query_mdb for running ClickHouse SQL. Clients like Claude Code, Claude Desktop and Posit Assistant can discover and invoke these tools using TKCat's documented data models, foreign keys and collections to answer questions spanning multiple databases. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What is the MCP server in TKCat 1.3.0 and what tools does it expose? TKCat 1.3.0 ships a read-only MCP server that lets AI assistants like Claude Code, Claude Desktop, or Posit Assistant explore and query modeled databases (MDBs) in a chTKCat (TKCat on ClickHouse) instance. It exposes tools such as list_mdbs, search_tkcat, describe_mdb, describe_tables, list_collections, preview_table, and query_mdb for running ClickHouse SQL. _Developers wiring AI assistants into existing databases can track MCP server releases like this one on daily.dev._ ### What is the difference between chTKCat_mcp_server() and chTKCat_mcp_http_server() in TKCat? chTKCat_mcp_server() runs a local MCP server started by the client on the user's own computer using stdio transport, requiring R and TKCat installed locally. chTKCat_mcp_http_server() runs as a remote service alongside the chTKCat instance using Streamable HTTP transport, so users don't need R or TKCat on their own machine. _Teams deciding between local and remote MCP deployments can follow database tooling updates like this on daily.dev._ ## Similar posts on daily.dev - [Powering Your Database Queries with a LLMs and MCPs](https://daily.dev/posts/powering-your-database-queries-with-a-llms-and-mcps-comvt7ljx) · The Miners · 2 upvotes · 0 comments - [MCP-Manticore: Let Your AI Assistant Write Manticore Queries for You](https://daily.dev/posts/mcp-manticore-let-your-ai-assistant-write-manticore-queries-for-you-qf5kp5wae) · Manticore · 0 upvotes · 0 comments - [10 MCP servers to connect LLMs with databases](https://daily.dev/posts/10-mcp-servers-to-connect-llms-with-databases-89pgeevcq) · InfoWorld · 2 upvotes · 0 comments - [Developing Documentation MCP Servers for IBM Bob](https://daily.dev/posts/developing-documentation-mcp-servers-for-ibm-bob-t4lycmzhj) · Niklas Heidloff · 1 upvotes · 0 comments - [Introducing the KurrentDB MCP Server for AI-powered Development](https://daily.dev/posts/introducing-the-kurrentdb-mcp-server-for-ai-powered-development-sqf7ljlyf) · Event Store · 1 upvotes · 1 comments --- Tags: [#r](https://daily.dev/tags/r), [#mcp](https://daily.dev/tags/mcp), [#clickhouse](https://daily.dev/tags/clickhouse) [View this post on daily.dev](https://daily.dev/posts/tkcat-meets-llms-an-mcp-server-for-well-documented-knowledge-resources-0abbyldwg) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"TKCat meets LLMs: an MCP server for well-documented knowledge resources","url":"https://daily.dev/posts/tkcat-meets-llms-an-mcp-server-for-well-documented-knowledge-resources-0abbyldwg","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/tkcat-meets-llms-an-mcp-server-for-well-documented-knowledge-resources-0abbyldwg"},"datePublished":"2026-10-21T11:12:13.487Z","dateModified":"2026-10-21T11:12:38.957Z","description":"TKCat 1.3.0 adds a read-only MCP server that lets AI assistants query modeled databases. The server comes in a local stdio form (chTKCat_mcp_server) and a...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/fb108d9389172c47e0add11ebfa97a17?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/fb108d9389172c47e0add11ebfa97a17?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"R-bloggers","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"R-bloggers","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/98bcbbdf72774292a55ceda8f2277f1e","url":"https://daily.dev/sources/rbloggers"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/tkcat-meets-llms-an-mcp-server-for-well-documented-knowledge-resources-0abbyldwg","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"r,mcp,clickhouse","timeRequired":"PT5M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"R-bloggers","item":"https://daily.dev/sources/rbloggers"},{"@type":"ListItem","position":3,"name":"TKCat meets LLMs: an MCP server for well-documented knowledge resources"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/tkcat-meets-llms-an-mcp-server-for-well-documented-knowledge-resources-0abbyldwg#faq","mainEntity":[{"@type":"Question","name":"What is the MCP server in TKCat 1.3.0 and what tools does it expose?","acceptedAnswer":{"@type":"Answer","text":"TKCat 1.3.0 ships a read-only MCP server that lets AI assistants like Claude Code, Claude Desktop, or Posit Assistant explore and query modeled databases (MDBs) in a chTKCat (TKCat on ClickHouse) instance. It exposes tools such as list_mdbs, search_tkcat, describe_mdb, describe_tables, list_collections, preview_table, and query_mdb for running ClickHouse SQL. Developers wiring AI assistants into existing databases can track MCP server releases like this one on daily.dev."}},{"@type":"Question","name":"What is the difference between chTKCat_mcp_server() and chTKCat_mcp_http_server() in TKCat?","acceptedAnswer":{"@type":"Answer","text":"chTKCat_mcp_server() runs a local MCP server started by the client on the user's own computer using stdio transport, requiring R and TKCat installed locally. chTKCat_mcp_http_server() runs as a remote service alongside the chTKCat instance using Streamable HTTP transport, so users don't need R or TKCat on their own machine. Teams deciding between local and remote MCP deployments can follow database tooling updates like this on daily.dev."}}]} ```