MCP Server
Faucet
SQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.
- Database Management
- By faucetdb
- 7 tools
Features
- Full CRUD REST API - GET, POST, PUT, PATCH, DELETE with filtering, ordering, and pagination
- Schema introspection - Discovers tables, columns, types, and constraints at runtime
- Schema DDL - Create, alter, and drop tables via API
- Stored procedure calls - Execute stored procedures with typed parameters
- Human-readable query filters - (age > 21) AND (status = 'active')
- OpenAPI 3.1 spec - Auto-generated from live database schema at /openapi.json
- API key authentication - SHA-256 hashed keys with per-key role assignment
- JWT authentication - HMAC-SHA256 signed tokens for admin sessions
Use cases
- Instant backend for apps - Skip writing CRUD APIs by hand. Point Faucet at your database and start building your frontend.
- AI agent data access - Give Claude, GPT, or any MCP-compatible agent governed, read/write access to your databases.
- Internal tools & dashboards - Generate APIs for internal databases without modifying existing infrastructure.
- Legacy database modernization - Put a REST API in front of SQL Server 2012, MySQL 5.7, or PostgreSQL 9.6 without code changes.
- Multi-database aggregation - Connect PostgreSQL, MySQL, SQL Server, Oracle, and more to a single Faucet instance and query them all through one API.
- Rapid prototyping - Go from empty database to working API in under 60 seconds.
Tools this MCP server exposes
faucet_list_servicesfaucet_list_tablesfaucet_describe_tablefaucet_insertfaucet_updatefaucet_deletefaucet_raw_sql
Frequently asked questions
What does Faucet do?
SQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.
Is Faucet open source?
Yes — faucetdb's source code is publicly available on GitHub, linked above.
What category is Faucet in?
Faucet is listed under Database Management.
What tools does Faucet expose?
Faucet exposes 7 tools: faucet_list_services, faucet_list_tables, faucet_describe_table, faucet_insert, faucet_update, faucet_delete, faucet_raw_sql.
Who maintains Faucet?
Faucet is built and maintained by faucetdb.