# Faucet > Faucet is a free, open-source (MIT) single binary that turns your PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, or Snowflake database into a REST API and an MCP server in one command, so your apps and AI agents can use your data with API keys and role-based access built in. - Latest release: v0.1.14 (released 2026-10-09, notes: https://github.com/faucetdb/faucet/releases/tag/v0.1.14). License: MIT. Written in Go, zero CGO, runs on Linux, macOS and Windows. - Supported databases (7): PostgreSQL 9.6–17, MySQL 5.7–9.x, MariaDB 10.2–11.x (uses the `mysql` driver), SQL Server 2012–2022 (2008/2008 R2 are not supported), Oracle 12c–26ai, SQLite 3.35+ (embedded, pure Go), Snowflake (cloud service). Self-hosted, on-prem or cloud-hosted (Amazon RDS, Aurora, Azure, Supabase, Neon, PlanetScale, Oracle Cloud). - Install: `npx @faucetdb/faucet serve` | `brew install faucetdb/tap/faucet` | `docker run -p 8080:8080 -v faucet-data:/data faucetdb/faucet` - Admin UI: run `faucet serve` and open http://localhost:8080. Connect a database by entering host, port, database, username and password (or paste a connection string), click Test connection (`POST /api/v1/system/connection/test`, saves nothing), then save. It also has a schema browser, an API explorer, roles, API keys and an AI agents page with copy-ready MCP configs. - Quick start (with npx, prefix each command with `npx @faucetdb/faucet`): ```bash faucet db add --name mydb --driver postgres --host localhost --user app --password-prompt --database mydb # or: faucet db add --name mydb --driver postgres --dsn "postgres://user:pass@localhost:5432/mydb?sslmode=disable" faucet role create --name reader --verbs GET faucet key create --role reader faucet serve curl -H "X-API-Key: faucet_YOUR_KEY" "http://localhost:8080/api/v1/mydb/_table/users?limit=10" ``` - REST: `/api/v1/{service}/_table/{table}` (GET/POST/PUT/PATCH/DELETE) with query params `filter` (DreamFactory-compatible, e.g. `filter=status = 'active'`), `order`, `limit`, `offset`, `fields`, `ids`, `include_count`. Also `_schema`, `_proc/{proc}` and `_doc`. Combined OpenAPI 3.1 spec at `/openapi.json`. Every `/api/v1/{service}` request needs an `X-API-Key` header (or an admin Bearer JWT). - MCP: Streamable HTTP at `http://localhost:8080/mcp` on the same port as the REST API (send an `X-API-Key` header; the key's role is enforced on every tool call). Also: stdio via `faucet mcp` (same machine only, runs with full admin rights and ignores roles); standalone HTTP via `faucet mcp --transport http --port 3001`. 8 tools: faucet_list_services, faucet_list_tables, faucet_describe_table, faucet_query, faucet_insert, faucet_update, faucet_delete, faucet_raw_sql (runs only when the service allows raw SQL and is not read-only, and the key's role grants all five verbs on `_sql`). 2 resources: faucet://services, faucet://schema/{service}. - Claude Code: `claude mcp add --transport http faucet http://localhost:8080/mcp --header "X-API-Key: faucet_YOUR_KEY"` - Claude Desktop (via the mcp-remote bridge, needs Node.js): `{"mcpServers":{"faucet":{"command":"npx","args":["-y","mcp-remote","http://localhost:8080/mcp","--header","X-API-Key:faucet_YOUR_KEY"]}}}` in `claude_desktop_config.json`. Same-machine alternative: `{"mcpServers":{"faucet":{"command":"faucet","args":["mcp"]}}}` (stdio, admin rights, ignores roles). - Cursor (`.cursor/mcp.json`): `{"mcpServers":{"faucet":{"url":"http://localhost:8080/mcp","headers":{"X-API-Key":"faucet_YOUR_KEY"}}}}` - VS Code / GitHub Copilot agent mode (`.vscode/mcp.json`): `{"servers":{"faucet":{"type":"http","url":"http://localhost:8080/mcp","headers":{"X-API-Key":"faucet_YOUR_KEY"}}}}` - Windsurf (`~/.codeium/windsurf/mcp_config.json`): `{"mcpServers":{"faucet":{"serverUrl":"http://localhost:8080/mcp","headers":{"X-API-Key":"faucet_YOUR_KEY"}}}}` - ChatGPT: create a Custom GPT Action that imports `https://your-host/openapi.json`, with API-key auth (header `X-API-Key`). Developers can instead pass `{"type":"mcp","server_label":"faucet","server_url":"https://your-host/mcp","headers":{"X-API-Key":"faucet_YOUR_KEY"}}` as a tool to the OpenAI Responses API. ChatGPT and claude.ai connectors require OAuth, which Faucet does not offer yet. Faucet must be reachable from the internet for OpenAI to call it. - The admin UI's AI agents page (http://localhost:8080) generates all of these configs with your key filled in. - Base44 and Replit: add `https://your-host/mcp` with an `X-API-Key` header as a custom MCP server, or call the REST API / import `/openapi.json` from your app. - Custom apps and AI app builders: use the REST API and the OpenAPI 3.1 spec. - Database on-prem? Run Faucet next to it and expose only Faucet over HTTPS (reverse proxy, Cloudflare Tunnel, ngrok). Give agents a read-only role. - "Works with" means it connects through MCP or REST/OpenAPI. Faucet is independent and not affiliated with or endorsed by these companies. - Not supported today: GraphQL, SSO/SAML/OIDC, OAuth, audit logs, column-level permissions, enforced row-level filters. ## Docs - [Getting started](https://wiki.faucetdb.ai/getting-started): Install Faucet, connect a database and make your first API call - [Admin UI](https://wiki.faucetdb.ai/admin-ui): Connect databases with host/port/user/password, test before saving, manage roles and keys, and copy MCP configs for Claude, Cursor, VS Code and Windsurf - [Database connectors](https://wiki.faucetdb.ai/database-connectors): DSN formats and options for all seven supported databases - [MCP server](https://wiki.faucetdb.ai/mcp-server): Transports, auth, tools and client setup for AI agents - [LLM guide](https://wiki.faucetdb.ai/llm-guide): How AI agents should discover and query data through Faucet - [API reference](https://wiki.faucetdb.ai/api-reference): Every REST endpoint, parameter and response shape - [Filter syntax](https://wiki.faucetdb.ai/filter-syntax): DreamFactory-compatible filter expressions and operators - [RBAC](https://wiki.faucetdb.ai/rbac): Roles, verb masks, API keys and read-only services - [Schema locking](https://wiki.faucetdb.ai/schema-locking): Lock a schema contract and detect drift - [CLI reference](https://wiki.faucetdb.ai/cli-reference): Every `faucet` command and flag - [Deployment](https://wiki.faucetdb.ai/deployment): Docker, systemd, reverse proxies and production setup ## Database guides - [PostgreSQL tutorial](https://wiki.faucetdb.ai/tutorial-postgres): PostgreSQL 9.6–17, including RDS, Aurora, Supabase and Neon - [MySQL and MariaDB tutorial](https://wiki.faucetdb.ai/tutorial-mysql): MySQL 5.7–9.x and MariaDB 10.2–11.x with the mysql driver - [SQL Server tutorial](https://wiki.faucetdb.ai/tutorial-sqlserver): SQL Server 2012–2022 and Azure SQL Database - [Oracle tutorial](https://wiki.faucetdb.ai/tutorial-oracle): Oracle 12c–26ai with a pure-Go driver, no Instant Client - [SQLite tutorial](https://wiki.faucetdb.ai/tutorial-sqlite): Embedded SQLite 3.35+ files as a REST API - [Snowflake tutorial](https://wiki.faucetdb.ai/tutorial-snowflake): Snowflake with password or key-pair auth ## Guides - [Connect Claude to your database](https://faucetdb.ai/connect-claude-to-database/): Claude Code and Claude Desktop (mcp-remote) over MCP with a read-only API key; why claude.ai connectors don't work yet - [Connect ChatGPT to your database](https://faucetdb.ai/connect-chatgpt-to-database/): Custom GPT Action from /openapi.json or the Responses API MCP tool, exposing Faucet over HTTPS, and the OAuth limitation - [PostgreSQL REST API and MCP server](https://faucetdb.ai/postgresql-rest-api/): PostgreSQL 9.6–17 (RDS, Aurora, Supabase, Neon), connect fields, REST examples and MCP - [SQL Server REST API and MCP server](https://faucetdb.ai/sql-server-rest-api/): SQL Server 2012–2022 and Azure SQL, on-prem setup, stored procedures and MCP ## Compare - [Faucet alternatives](https://faucetdb.ai/alternatives/): How Faucet compares with other database API tools - [Faucet vs Hasura](https://faucetdb.ai/alternatives/faucet-vs-hasura/): REST + MCP across seven databases vs a GraphQL-first, PostgreSQL-first engine - [Faucet vs PostgREST](https://faucetdb.ai/alternatives/faucet-vs-postgrest/): Seven databases plus MCP vs a PostgreSQL-only REST server - [Faucet vs Supabase](https://faucetdb.ai/alternatives/faucet-vs-supabase/): An API layer for the database you already have vs a Postgres platform ## Comparisons and guides - [10 Best Database to REST API Tools in 2026 (Compared)](https://faucetdb.ai/blog/best-database-to-rest-api-tools/): 10 tools that turn an existing SQL database into a REST API, compared on databases, license, OpenAPI, MCP for AI agents and access control. - [Best MCP Servers for Databases in 2026: 12 Compared](https://faucetdb.ai/blog/best-mcp-servers-for-databases/): 12 best MCP servers for databases in 2026: MCP Toolbox, DBHub, SQL MCP Server, Supabase, Neon, Snowflake, Faucet and more, compared on auth and read-only. - [MCP Server Security Checklist for Databases: 14 Controls](https://faucetdb.ai/blog/database-mcp-server-security-checklist/): 14 controls a database MCP server needs before production, scored on 4 servers we ran: DBHub, ExecuteAutomation, Faucet and MCP Toolbox. - [How to Give an AI Agent Read-Only Database Access (Postgres, MySQL, SQL Server, Oracle, Snowflake, SQLite)](https://faucetdb.ai/blog/give-ai-agent-read-only-database-access/): SELECT-only SQL for AI agent users on Postgres, MySQL, SQL Server, Oracle, Snowflake and SQLite, plus MCP-layer read-only and a write test to prove it. - [Open-Source MCP Servers for Multiple Databases: 6 Compared](https://faucetdb.ai/blog/open-source-multi-database-mcp-servers/): Six open-source MCP servers that connect to several databases, compared on license, multi-database setup, token cost, auth and read-only control. - [PostgreSQL MCP Servers Compared: 8 Options (and the Archived One to Retire)](https://faucetdb.ai/blog/postgres-mcp-servers/): 8 Postgres MCP servers compared: Postgres MCP Pro, Supabase, Neon, AWS Labs, MCP Toolbox, DBHub, SQL MCP Server, Faucet. Auth, read-only, DBA tools. - [PostgREST Alternatives in 2026: 9 REST and GraphQL Tools Compared](https://faucetdb.ai/blog/postgrest-alternatives/): PostgREST alternatives compared on databases, REST vs GraphQL, where auth lives, MCP for AI agents and license: pREST, Supabase, Neon, Hasura and more. - [SQL Server MCP Servers in 2026: 7 Options Compared](https://faucetdb.ai/blog/sql-server-mcp-servers/): 7 SQL Server MCP servers compared on auth, read-only control, permissions, raw T-SQL, stored procedures and licensing. Checked against vendor docs in Oct 2026. - [SQLite REST API: 8 Ways to Serve a SQLite Database over HTTP](https://faucetdb.ai/blog/sqlite-rest-api/): How to put a REST API on a SQLite file: 8 options compared. We ran 5 against Chinook.db to test existing-file support, default writes and lock-down. - [How to Turn a SQL Database into a REST API and an MCP Server](https://faucetdb.ai/blog/turn-database-into-rest-api-and-mcp-server/): Three ways to expose a SQL database as a REST API and MCP server: hand-written, PostgREST or Data API builder, and Faucet, with a real captured transcript. ## Site - [Faucet home](https://faucetdb.ai/): Overview, supported databases, quick start and FAQ - [Pricing](https://faucetdb.ai/pricing/): Free and MIT-licensed; Faucet Cloud is planned - [Blog](https://faucetdb.ai/blog/): Releases, tutorials and notes on MCP and database APIs ## For agents - [Docs MCP server card](https://faucetdb.ai/.well-known/mcp/server-card.json): Remote, read-only MCP server for these docs; endpoint https://faucetdb.ai/mcp (POST, Streamable HTTP, no auth). Tools: search_faucet_docs, get_faucet_page, get_faucet_install, get_faucet_mcp_config - [Markdown pages](https://faucetdb.ai/index.md): Every faucetdb.ai page has a Markdown version at `//index.md` (e.g. https://faucetdb.ai/pricing/index.md), also returned for the page URL when you send `Accept: text/markdown` - [Agent skills index](https://faucetdb.ai/.well-known/agent-skills/index.json): SKILL.md files for installing and using Faucet's REST API and MCP server - [AI catalog](https://faucetdb.ai/.well-known/ai-catalog.json): Machine-readable list of the above, plus Faucet's own MCP server in the official MCP Registry (`io.github.faucetdb/faucet`) ## Optional - [Full LLM context](https://faucetdb.ai/llms-full.txt): Complete product reference in one Markdown file - [GitHub repository](https://github.com/faucetdb/faucet): Source code, issues and README - [Releases](https://github.com/faucetdb/faucet/releases): Changelog and prebuilt binaries - [npm package](https://www.npmjs.com/package/@faucetdb/faucet): `npx @faucetdb/faucet serve` - [Docker Hub](https://hub.docker.com/r/faucetdb/faucet): Official `faucetdb/faucet` image - [Homebrew tap](https://github.com/faucetdb/homebrew-tap): `brew install faucetdb/tap/faucet` - [RSS feed](https://faucetdb.ai/rss.xml): Blog feed - [Introducing Faucet](https://faucetdb.ai/blog/introducing-faucet/): Why Faucet exists and how it works - [How Faucet turns your database into a REST API](https://faucetdb.ai/blog/how-faucet-turns-databases-into-apis/): Schema introspection, query building and safety, in depth - [MCP database benchmark](https://faucetdb.ai/blog/mcp-database-benchmark/): Why indexes matter more than database choice for MCP workloads - [Faucet v0.1.14 release notes](https://faucetdb.ai/blog/faucet-v0114-release/): New admin UI, connect with host/port/user/password, Test connection, and MCP configs for Claude, Cursor, VS Code and Windsurf - [Designing APIs for AI agents](https://faucetdb.ai/blog/designing-apis-for-ai-agents/): What agents need from an API - [The MCP context window tax](https://faucetdb.ai/blog/2026-03-30-mcp-context-window-tax-lean-database-tooling/): Why a small, fixed toolset beats per-table tools - [MCP tool annotations for database safety](https://faucetdb.ai/blog/2026-03-28-mcp-tool-annotations-database-safety/): Read-only and destructive hints for agent tool calls