
Faucet
SQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.
- GitHub stars
- 170
- tools
- 8
- transport
- STDIO, HTTP
- env var
- 1
- last updated
- Oct 9, 2026
Tools
8 toolsPublic tool metadata for what this MCP can expose to an agent.
faucet_list_servicesList all connected databases
List all connected databases
No parameter schema in public metadata yet.
faucet_list_tablesList tables in a database
List tables in a database
No parameter schema in public metadata yet.
faucet_describe_tableGet column names, types, and constraints
Get column names, types, and constraints
No parameter schema in public metadata yet.
faucet_queryQuery records with filters, ordering, pagination
Query records with filters, ordering, pagination
No parameter schema in public metadata yet.
faucet_insertInsert new records
Insert new records
No parameter schema in public metadata yet.
faucet_updateUpdate existing records
Update existing records
No parameter schema in public metadata yet.
faucet_deleteDelete records
Delete records
No parameter schema in public metadata yet.
faucet_raw_sqlExecute raw SQL (admin only)
Execute raw SQL (admin only)
No parameter schema in public metadata yet.
Sponsors
Configuration
FAUCET_DATA_DIRFaucet data directory holding the databases you connected with `faucet serve` or `faucet db add`. Default: ~/.faucet. stdio mode runs with local admin rights.
Readme
Faucet logo
Faucet: REST API and MCP server for any SQL database
Turn any SQL database into a secure REST API and MCP server.
One binary. One command.
Faucet is an open-source (MIT) single Go binary that turns PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake or SQLite into a REST API and an MCP server for AI agents, with role-based access control (RBAC), OpenAPI 3.1 and a built-in admin UI.
Endpoints, OpenAPI specs and MCP tools are generated from your database schema at runtime. No code generation, no ORM, no boilerplate.
Details
- Repository
- github.com/faucetdb/faucet
- Website
- wiki.faucetdb.ai/mcp-server
- Categories
- Databases, Data & Analytics
- Package
@faucetdb/faucet- Transport
- STDIO, HTTP
- Registry
- MCP registry, active