# Faucet: REST API and MCP server for any SQL database

Source: https://wiki.faucetdb.ai/

> Faucet is an open-source single binary that turns PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite or Snowflake into a REST API and MCP server.

Turn any SQL database into a secure REST API and an MCP server for AI agents. One open-source binary, with roles, API keys and a built-in admin UI.

- **Seven Databases, One Interface:** PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake, and SQLite — all through a unified REST API with consistent filtering and pagination. ([docs](https://wiki.faucetdb.ai/database-connectors))
- **Point-and-Click Setup:** Connect a database in the built-in admin UI with host, port, user, and password. Faucet tests the connection before saving, then hands you copy-ready API and MCP snippets. ([docs](https://wiki.faucetdb.ai/admin-ui))
- **Single Binary:** No runtime dependencies, no framework overhead. Download one binary and run it. Embeds admin UI, OpenAPI docs, and MCP server. ([docs](https://wiki.faucetdb.ai/getting-started))
- **Role-Based Access Control:** Fine-grained permissions per table, per role. Control who can read, write, or admin each resource through simple configuration. ([docs](https://wiki.faucetdb.ai/rbac))
- **AI Agents (MCP):** An MCP endpoint at /mcp on the same port as the REST API, authenticated with an API key whose role decides what an agent can see and change. Copy-ready configs for Claude Code, Claude Desktop, Cursor, VS Code and Windsurf; ChatGPT works through a Custom GPT Action. ([docs](https://wiki.faucetdb.ai/mcp-server))
- **OpenAPI 3.1:** A combined OpenAPI 3.1 spec at /openapi.json, generated from your live schema, for SDK generators, Custom GPT Actions and AI app builders. ([docs](https://wiki.faucetdb.ai/ai-app-builders))

Start here: [Getting Started](https://wiki.faucetdb.ai/getting-started)