Byaan MCP
The Byaan MCP server lets Claude Code and Cursor put questions to your databases and returns queries with read-only results.
- 96 ★ on the repository
- Last commit
Extended access
Why this level
- Data from your databases reaches an external model if a cloud provider is chosen.
- The Community version has no authentication and the write guard works at application level.
Install
- Works in
Manual install
git clone https://github.com/byaan-ai/byaan.git && cd byaan && docker compose up -dThe Community version runs in Docker and opens at `http://localhost:17434`. A Mac app and a team version also exist.
Access and checks
How we reviewExtended accessThe tool runs code or makes network calls and only reads external data.
- Data from your databases reaches an external model if a cloud provider is chosen.
- The Community version has no authentication and the write guard works at application level.
This is third-party code. Review the repository files before installing.
What it does
Byaan is an open-source AI analyst: it discovers database schemas, remembers metric definitions and business rules, and builds queries, charts and dashboards. Its MCP server gives the same abilities to an agent inside an editor or terminal. It connects PostgreSQL, MySQL, MongoDB, SQLite, MSSQL, ODBC and CSV, Excel, Parquet and JSON files. The user picks the model: Claude, OpenAI, Azure OpenAI, AWS Bedrock, Groq, OpenRouter or xAI. A read-only guard validates queries and blocks known write operations. The repository ships the `/byaan:start`, `/byaan:learn` and `/byaan:mcp-setup` skills. The first deploys the service and wires up MCP, the second re-reads the schema after changes.
Who it is for. Analysts and developers who need database answers without hand-written SQL, and teams ready to self-host the service.
Good fit when
- A manager asks the agent how many orders were returned this quarter and needs the query, not only the number
- The database schema changed and the agent must re-read the tables with `/byaan:learn`
- Claude Code is open in a terminal while the data sits in Parquet or Excel on disk
- The company's definition of revenue is complicated and should be recorded once for every later question
Not a fit when
- You need to write to the database: the guard blocks data changes
- A shared server without access control: the Community version has no built-in authentication
- Data cannot go to an external model vendor and there is no local model
Example request
List the tables in my database, then find the ten customers with the largest order totals this year and show the query.MCP
- Transport
- stdio, http
- Authentication
- not required
Limitations
Schema fragments and query results go to the model provider you pick. The Community version has no authentication: run it locally or on a closed network. The write guard works at application level, so create a read-only user for production databases. The `server/ee/` folder uses the Elastic License 2.0 and the rest of the code is MIT. The cloud version asks for an MCP key.
How to disable. Remove the `byaan` entry from MCP settings (`claude mcp remove byaan`) and stop the container with `docker compose down`. Saved schema knowledge lives in the application's local database.
FAQ
How do I connect Byaan to Claude Code?
Run `claude mcp add-json byaan` with the configuration from the README: for the Mac app it points to the bundled binary, for a local build it uses `uv run python -m server.mcp.stdio_server`. To check, ask the agent to list the tables.
Can Byaan change data in my database?
No, it is designed for reading: queries pass guard layers for SQL, MongoDB, DynamoDB and DuckDB. This is an extra safeguard, so production databases still need a read-only user.
Which databases and files are supported?
PostgreSQL, MongoDB, MySQL, SQLite, MSSQL, ODBC, plus CSV, Excel, Parquet and JSON files. DuckDB processes files on your own machine.
Do I need an account for Byaan?
The Mac app and the Community version need no account: the model is configured inside the app. The cloud version asks for an MCP key from the profile.
What leaves my network?
Database connections stay with you, while schema and query results may go to the chosen model provider. Database traffic does not pass through Byaan servers.
Discussion
No questions or reviews yet.
Related
MCP serversArcadeDB ships a built-in MCP server: an agent reads graph, document and vector data, and writes are opt-in.
One MCP server for SQLite, SQL Server, PostgreSQL and MySQL: read and change data, edit schemas and export to CSV and JSON
A SQLite-based SQL engine with plugins for apps, databases and files: the anyquery mcp command exposes that data to Claude, Cursor and other MCP clients
A lightweight database workspace with an MCP server: the agent reads the schema, runs queries and explores data in PostgreSQL, MySQL and more
A Go MCP server that lets an agent ask a PostgreSQL database questions in plain language and returns the query result
Keboola MCP Server opens the Keboola data platform to assistants: tables, SQL transformations, jobs, flows and data apps.
Comparison with similar tools
Cards that share the main search query, and how they differ.
| Tool | Official | Authentication | Repository stars | Main difference |
|---|---|---|---|---|
| Byaan (this card) | yes | not required | 96 | |
| DBHub | no | not required | 3,839 | a generic MCP gateway to databases; Byaan keeps metric definitions and builds dashboards |
| Postgres MCP Pro | no | API key | 3,469 | focused on PostgreSQL; Byaan connects several databases and files |
README in short
Byaan runs as a Mac app, a Docker container or a team version with authentication. In every variant the agent connects through MCP, and schema and metric definitions accumulate between sessions.