Kyomi
@kyomi-ai
About Kyomi
Kyomi MCP Server — query your data warehouse from Claude Code, Cursor, and any MCP client
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.
Frequently asked questions
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`.
Basic information
More Databases MCP servers
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
Comments