BridgeMCP — Secure Read-Only AI Data Gateway by JIANBIN LIUBridgeMCP — Secure Read-Only AI Data Gateway by JIANBIN LIU

BridgeMCP — Secure Read-Only AI Data Gateway

JIANBIN LIU

JIANBIN LIU

BridgeMCP — Secure Read-Only AI Data Gateway
The challenge Teams want AI to answer questions from business data without exposing database credentials or allowing unsafe queries.
The solution I designed and built a security boundary that turns SQLite files or CSV folders into restricted MCP tools. The gateway enforces read-only access, table allowlists, sensitive-field masking, result limits, timeouts, and complete query auditing.
Engineering highlights • Three independent read-only enforcement layers • Automatic phone and email masking with anti-bypass checks • Row, byte, and execution-time limits • Full audit records for accepted and rejected calls
Full source code and setup instructions: https://github.com/LuciferLiu/bridgemcp
Like this project

Posted Jul 27, 2026

Built a security-first MCP gateway that exposes business data as read-only AI tools with table allowlists, PII masking, query limits, and complete audit logs.