# Introducing Faucet: Turn Your SQL Database into a REST API

> Faucet is a free, open-source single binary that turns your SQL database into a REST API and MCP server. Here's why we built it and how it works.

Source: https://faucetdb.ai/blog/introducing-faucet/

Faucet Team · February 24, 2026 · Updated October 8, 2026 · 2 min read

Tags: announcement, open-source, release

_Updated October 2026: Faucet now supports seven databases (including MariaDB) and the latest release is v0.1.14 ([release notes](https://faucetdb.ai/blog/faucet-v0114-release/))._

Faucet is an open-source server that turns your SQL database into a REST API, with API keys and role-based access built in, in under 60 seconds. No Docker required. No runtime dependencies. Just one binary.

## The Problem

Building REST APIs for databases is tedious. You write the same CRUD endpoints, the same authentication middleware, the same pagination logic — over and over. Existing solutions either lock you into one database (PostgREST), require a heavier server stack (DreamFactory), or are GraphQL-first (Hasura).

## The Solution

Faucet takes a different approach: **one binary, seven databases**. Point it at PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, or Snowflake — and get a full REST API with:

- **Role-based access control** with per-table, per-verb permissions
- **OpenAPI 3.1 documentation** generated automatically from your schema
- **Native MCP server** so AI agents like Claude can query your data directly
- **Embedded admin UI** for managing connections, roles, and API keys

## Built Small

- **A single static binary with zero runtime dependencies**
- **Pure Go, no CGO** — runs the same on Linux, macOS, and Windows
- **Connection pooling built in**, plus `faucet benchmark` to measure your own setup

## Get Started

Install Faucet in one command:

```bash
brew install faucetdb/tap/faucet
faucet db add --name mydb --driver postgres --dsn "postgres://user:pass@localhost:5432/mydb?sslmode=disable"
faucet serve
```

Your REST API is now live at `http://localhost:8080/api/v1/mydb/_table/` — create a role and an API key (`faucet role create --name reader --verbs GET`, then `faucet key create --role reader`) and send it in the `X-API-Key` header.

## What’s Next

We’re actively developing Faucet and shipping fast. Follow our progress on [GitHub](https://github.com/faucetdb/faucet) and star the repo to stay updated.

Faucet is MIT licensed and free forever. [Get started today](https://wiki.faucetdb.ai/getting-started).

Turn on the data.

## Try Faucet in 60 seconds

```
brew install faucetdb/tap/faucet   # or: npx @faucetdb/faucet serve, then use the admin UI
faucet db add --name mydb --driver postgres --host localhost --user app --password-prompt --database mydb
faucet role create --name reader --verbs GET
faucet key create --role reader
faucet serve   # admin UI, REST API and MCP at http://localhost:8080
```

[Star on GitHub](https://github.com/faucetdb/faucet) [Quick start docs](https://wiki.faucetdb.ai/getting-started) [Connect Claude, ChatGPT, Cursor](https://faucetdb.ai/#mcp)

Faucet is free and open source (MIT). Works with PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite and Snowflake.

## Keep reading

[Open-Source MCP Servers for Multiple Databases: 6 Compared](https://faucetdb.ai/blog/open-source-multi-database-mcp-servers/) (Oct 19, 2026): Six open-source MCP servers for several databases, four of them run on the same SQLite file: writes, read-only, auth, tool tokens and cold start.

[SQLite REST API: 8 Ways to Serve a SQLite Database over HTTP](https://faucetdb.ai/blog/sqlite-rest-api/) (Oct 19, 2026): Eight ways to put a REST API on a SQLite database: Datasette, PocketBase, Turso, Cloudflare D1, Faucet, sqlite-rest, ws4sqlite and Directus. We ran five of them against the same Chinook.db file and checked whether each one serves an existing file, what writes get through with default settings, and how you lock it down.

[Faucet v0.1.7: Oracle Database Support — 7 Databases, One Binary](https://faucetdb.ai/blog/faucet-v017-release/) (Mar 2, 2026): Faucet v0.1.7 adds full Oracle Database support (12c through 26ai) using a pure-Go driver. No Oracle Instant Client required. Connect Oracle alongside PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, and Snowflake with a single Faucet binary.
