Faucet
faucetdb/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
Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthly
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any language
Agent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any languageConfiguration
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
