Faucet is an open-source, single-binary gateway that connects to major SQL databases—including PostgreSQL, MySQL, SQL Server, Oracle, Snowflake, and SQLite—and automatically generates full CRUD REST APIs and MCP tools at runtime. Without requiring code generation or ORMs, it equips developers and AI agents (such as Claude, Cursor, and Windsurf) with instant, governed data access protected by role-based access control (RBAC), API keys, and auto-generated OpenAPI 3.1 specifications.
주요 기능
01Automatic schema introspection generating full CRUD REST endpoints and OpenAPI 3.1 documentation at runtime
02Granular access management using API key authentication, JWT sessions, and per-table role-based access control
03Broad database support spanning PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake, and SQLite
04170 GitHub stars
05Built-in Model Context Protocol (MCP) server supporting streamable HTTP and stdio transports for AI agents
06Embedded web-based admin UI to configure connections, inspect schemas, manage keys, and test queries
사용 사례
01Provide AI coding assistants and autonomous agents with secure, governed read and write database access via MCP
02Instantly generate production-ready REST APIs and documentation for legacy databases or rapid frontend prototyping
03Aggregate multiple disparate SQL database engines under a single unified API and permission layer