Business Data MCP Server
Provides read-only querying of SQLite databases, including schema exploration and guarded SELECT execution with column masking, access-policy enforcement, and audit logging.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
Business Data MCP Server
A read-only Model Context Protocol server that lets Claude (Claude Desktop, Claude Code or any MCP client) answer business questions on a company database in plain language, without ever being able to change data or see what it shouldn't.
"Which product category generated the most revenue in Germany last quarter?" Claude explores the schema, writes the SQL, the server checks it against the access policy, runs it read-only and logs the call.
Demo project built on a sample sales database (customers, products, orders). The same pattern applies to any SQL database (PostgreSQL, Oracle, SQL Server) by swapping the database layer.
Why it is safe
Security is enforced inside the database engine, not only by inspecting the SQL text:
Layer | What it does |
Read-only connection | SQLite is opened with |
Engine-level authorizer | Only |
Column masking | Personal data ( |
Static SQL guard | Rejects multiple statements, |
Resource limits | Hard cap on returned rows and an execution budget that stops runaway queries (e.g. infinite recursive CTEs). |
Audit log | Every tool call (accepted or rejected, with SQL, row count and timing) is appended to a JSON Lines file. |
The access policy is declarative (src/bizdata_mcp/policy.py):
DEFAULT_POLICY = AccessPolicy(
allowed_tables=frozenset({"customers", "products", "orders", "order_items"}),
masked_columns={"customers": frozenset({"email", "phone"})},
)Related MCP server: Guarded Postgres MCP Server
Tools exposed to the model
Tool | Description |
| Tables the assistant is allowed to query |
| Columns, types, primary keys and which columns are masked |
| Runs one read-only |
All tools are annotated as readOnlyHint so clients can run them without extra confirmation prompts.
Architecture
Claude ──MCP (stdio)──▶ server.py ──▶ BusinessDataTools ──▶ ReadOnlyDatabase ──▶ SQLite (mode=ro)
│ ├─ sql_guard (static checks)
│ ├─ authorizer (policy, masking)
▼ └─ progress handler (budget)
audit.jsonlQuick start
Requires Python 3.11+.
pip install -e ".[dev]"
bizdata-seed data/sales.db # create the sample database
pytest # 29 testsUse it from Claude Desktop
Add to claude_desktop_config.json:
{
"mcpServers": {
"business-data": {
"command": "bizdata-mcp",
"env": {
"BIZDATA_DB": "/absolute/path/to/data/sales.db",
"BIZDATA_AUDIT": "/absolute/path/to/logs/audit.jsonl"
}
}
}
}Use it from Claude Code
claude mcp add business-data --env BIZDATA_DB=$PWD/data/sales.db -- bizdata-mcpExample audit log entry
{"ts": "2026-11-17T12:04:31+0100", "tool": "run_query", "outcome": "rejected",
"sql": "SELECT * FROM payroll", "reason": "Query touches a table or operation outside the access policy."}Tests
The suite covers the SQL guard, the engine-level policy (hidden tables, masked columns, sub-queries, row cap, runaway queries, write attempts that bypass the guard) and an end-to-end run through a real MCP client session.
Tech
Python 3.11+, MCP Python SDK 2.x, SQLite, pytest.
License
MIT
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Query 40 databases from Claude, ChatGPT, or Cursor — on any device. Read-only, encrypted, audited.
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Query, explore, and manage your databases through natural conversation.
Related MCP Servers
- AlicenseNot gradedqualityBmaintenanceEnables Claude Code to securely interact with PostgreSQL, MySQL, SQLite, and SQL Server databases, featuring read-only mode, query validation, SSH tunneling, and field redaction for production-safe data access.4MIT
- AlicenseNot gradedqualityCmaintenanceEnables Claude to query and safely write to a Postgres database, driven entirely by one policy file with read-only access by default, column-precise PII masking, and an append-only audit log. SQL is parsed and validated before execution, writes use parameterized queries with dry-run/confirm and transactions, and every call is rate-limited and audited so destructive or exfiltrating requests are refused.MIT
- AlicenseAqualityCmaintenanceEnables Claude to answer questions from PostgreSQL databases using read-only SQL queries, with row caps, column masking, and an audit log while preventing data changes.3MIT
- AlicenseAqualityCmaintenanceEnables Claude to answer business questions against a company's retail database — sales summaries, top customers, inventory alerts, customer profiles, and plain-English queries — through read-only SQL tools plus a schema resource and reporting prompt. Access is governed by OAuth 2.1 roles and scopes, column-level PII masking, a SQL guard, rate limits, and audit logging.5MIT