Kyomi

@kyomi-ai

Repository Homepage

About Kyomi

Kyomi MCP Server — query your data warehouse from Claude Code, Cursor, and any MCP client

#data-warehouse #bigquery #snowflake #postgresql #mysql #clickhouse #analytics #dashboards #sql #business-intelligence #monitoring #mcp

Basic information

Category

Databases

Transports

stdio

Publisher

kyomi-ai

Submitted by

Jason Adams

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "kyomi": {
      "type": "http",
      "url": "https://app.kyomi.ai/mcp"
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Kyomi?

Kyomi is an MCP server that enables AI assistants to query your data warehouse, access dashboards, automated monitoring, and accumulated business knowledge. It integrates with Claude Code, Cursor, and any MCP-compatible client.

How to use Kyomi?

Install via Claude Code with claude mcp add kyomi --transport http https://app.kyomi.ai/mcp, or connect via Cursor settings. Manual configuration is also possible. Restart the client and authorize in your browser on first use.

Key features of Kyomi

Semantic search across data catalog
Run SQL queries and validate syntax
Access team's accumulated business knowledge
Create and search dashboards with ChartML
Set up automated data monitoring with alerts
Manage website analytics tracking

Use cases of Kyomi

Find tables related to customer orders
Get column details for a specific table
Run revenue queries by product category
Retrieve business knowledge about metrics like MRR
Create dashboards showing weekly active users trend

FAQ from Kyomi

What data platforms does Kyomi support?

Kyomi connects to BigQuery, Snowflake, PostgreSQL, MySQL, ClickHouse, Redshift, Databricks, SQL Server, and Azure Synapse.

How does authentication work?

Browser-based OAuth is used; tokens refresh automatically. Workspace isolation and your existing Kyomi credentials apply.

Is my data copied or stored by Kyomi?

No. Kyomi queries your warehouse directly and never copies or stores your data. A 20-row preview limit is enforced for AI queries.

Can I deploy Kyomi on-premise for maximum security?

Yes, Kyomi Connect (open-source, Apache 2.0) can be deployed inside your network so database credentials never leave your infrastructure.

Where is the MCP configuration file stored?

For Cursor: ~/.cursor/mcp.json; for Claude Code: ~/.claude/claude_desktop_config.json.

Comments

More Databases MCP servers

Dbhub

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

Neon MCP Server

MCP server for interacting with Neon Management API and databases

Redis

modelcontextprotocol

Model Context Protocol Servers

MongoDB Lens

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

MCP Server for Milvus

Model Context Protocol Servers for Milvus