# Faucet v0.1.14: New Admin UI, Test-Before-Save Connections

> Faucet v0.1.14: connect databases with plain fields, test before saving, and copy MCP configs for Claude, Cursor, VS Code and Windsurf from the admin UI.

Source: https://faucetdb.ai/blog/faucet-v0114-release/

Kevin McGahey · October 9, 2026 · 6 min read

**Faucet v0.1.14: a new admin UI, test-before-save connections, and MCP setup for Claude, Cursor, VS Code and Windsurf**

Faucet v0.1.14 rebuilds the admin UI: connect any of seven databases with host, port, username and password instead of a connection string, test the connection before saving, and copy ready-made MCP configs for Claude Code, Claude Desktop, Cursor, VS Code, Windsurf and ChatGPT.

Tags: release, v0.1.14, admin ui, mcp

Faucet v0.1.14 is out. It is mostly one big change: a rebuilt admin UI. You can now connect a database by typing the same host, port, username and password you would give any database client, check that it works with **Test connection** before anything is saved, and copy a ready-made MCP config for the AI tool you use. Get it from [GitHub Releases](https://github.com/faucetdb/faucet/releases/tag/v0.1.14), npm, Homebrew or Docker Hub (upgrade commands are at the end).

If you are new here: [Faucet](https://faucetdb.ai/) is a free, MIT-licensed single binary that turns PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite or Snowflake into a REST API and an MCP server, with API keys and roles built in.

## Connect a database without writing a connection string

Before v0.1.14, adding a database meant writing a DSN, and every driver wants a different one: MySQL wants `tcp(host:port)`, SQL Server wants `sqlserver://...?database=`, and an `@` in a password has to be percent-encoded. That was the most common place for a first run to go wrong.

Now the **Add database** panel asks for fields:

| Database | Fields |
| --- | --- |
| PostgreSQL | Host, port (default 5432), database, username, password, SSL mode |
| MySQL, MariaDB | Host, port (3306), database, username, password, TLS |
| SQL Server | Host, port (1433), database, username, password, encryption, Trust server certificate |
| Oracle | Host, port (1521), service name, username, password, TLS |
| Snowflake | Account identifier, username, password or key pair, database, schema, warehouse, role |
| SQLite | File path |

Faucet builds and escapes the connection string for you, so passwords with `@`, `#`, `/` or `%` just work. Already have a DSN? Switch to **Connection string** and paste it.

![Faucet admin UI: adding a PostgreSQL database with host, port, database, username, password and SSL mode fields, and a Test connection button](https://faucetdb.ai/screenshots/add-database-1200.webp)

_Add a database: the same fields you give any database client._

## Test before you save

**Test connection** opens a temporary connection, pings the database, lists its tables and closes the connection. Nothing is saved. On success it tells you how many tables it found; on failure it shows the database’s own error with a plain-language hint for the usual suspects: connection refused, unknown host, timeouts, wrong credentials, a missing database or Oracle service name, TLS mismatches and SQLite files that can’t be opened.

**Add database** runs the test for you if you haven’t. If the database isn’t reachable yet but will be, **Save anyway** stores it.

![Faucet first-run setup: a PostgreSQL database tested successfully, showing Connected. Found 4 tables.](https://faucetdb.ai/screenshots/setup-connect-1200.webp)

_Test connection reports how many tables it found before you save._

The same check is available to scripts as a new endpoint, `POST /api/v1/system/connection/test`. It takes the same body as creating a service (`driver` plus `connection` fields or a `dsn`), needs an admin session, and saves nothing:

```bash
# ADMIN_TOKEN is an admin session token from POST /api/v1/system/admin/session
curl -X POST http://localhost:8080/api/v1/system/connection/test \
  -H "Authorization: Bearer $ADMIN_TOKEN" -H "Content-Type: application/json" \
  -d '{"driver":"postgres","connection":{"host":"localhost","username":"app","password":"...","database":"shop"}}'
```

A success returns `{"success": true, "table_count": 4, "tables": [...], "latency_ms": 38}`. The full shape is in the [API reference](https://wiki.faucetdb.ai/api-reference).

The CLI got the same treatment. `faucet db add` takes the connection as separate flags, and `--password-prompt` keeps the password out of your shell history:

```bash
faucet db add --name shop --driver postgres \
  --host db.internal --user app --password-prompt --database shop
faucet db add --name local --driver sqlite --path ./shop.db
```

`--dsn` still works exactly as before.

## Connect an AI agent from the AI agents page

Faucet’s MCP server lives at `/mcp` on the same port as the REST API. Agents send an API key in the `X-API-Key` header, and the key’s role decides which databases and tables they see and what they may change.

The new **AI agents** page turns that into copy and paste. Paste an API key once and it fills in a working config for each client, with the location of the config file:

- **Claude Code:** `claude mcp add --transport http faucet http://localhost:8080/mcp --header 'X-API-Key: ...'`
- **Cursor:** `~/.cursor/mcp.json` or `.cursor/mcp.json`
- **VS Code:** `.vscode/mcp.json`, used from GitHub Copilot Chat in agent mode
- **Windsurf:** `~/.codeium/windsurf/mcp_config.json`
- **Claude Desktop:** through the `mcp-remote` bridge, because Claude Desktop’s config file only launches local commands
- **Same machine:** `faucet mcp` over stdio. This runs with full admin rights and ignores roles, so keep it for your own machine.
- **ChatGPT:** see below
- **Test with curl:** an MCP handshake to check the URL and key

It also lists every tool an agent can call, marked **Read** or **Writes data**, and which databases are exposed, with their read-only and raw SQL settings.

![Faucet AI agents page with the MCP endpoint, client setup tabs for Claude Code, Cursor, VS Code, Windsurf, Claude Desktop and ChatGPT, and the list of MCP tools](https://faucetdb.ai/screenshots/ai-agents-1200.webp)

_The AI agents page: pick a client, paste a key, copy the config._

### A note on ChatGPT

ChatGPT’s connectors sign in with OAuth, and Faucet doesn’t offer OAuth yet, so you can’t add Faucet as a ChatGPT connector today. Two routes do work: a **Custom GPT Action** that imports `https://your-host/openapi.json` and authenticates with an API key in the `X-API-Key` header, or the **OpenAI Responses API**, which accepts Faucet as an MCP tool. Either way OpenAI calls Faucet from its own servers, so Faucet has to be reachable from the internet. Use a read-only key.

## The rest of the admin UI

Every page was redesigned. The highlights:

- **First-run setup** walks you through creating an admin, connecting a database and making a first request.
- **Overview** has a getting-started checklist, the REST, MCP and OpenAPI URLs, and a ready-to-run request in curl, JavaScript and Python.
- **Schema** shows columns, keys and clickable foreign keys, previews table data, and shows schema drift for locked tables.
- **API explorer** builds and sends requests as your admin session or as a specific API key, then copies them as code.
- **Roles** start from one-click presets and describe what a role allows in plain words.
- **API keys** can expire, and a new key is shown once with snippets that already contain it.
- A light theme, and layouts that work on a phone.

![Faucet API explorer building a GET request on the orders table with a filter of status = shipped and a limit of 3](https://faucetdb.ai/screenshots/api-explorer-1200.webp)

_The API explorer sends a request and copies it as curl, JavaScript or Python._

The release also fixes a blank page at `/admin`, `GET /mcp` returning HTML to MCP clients, double-encoded DSN passwords, and unescaped HTML in the JSON viewer.

The [Admin UI guide](https://wiki.faucetdb.ai/admin-ui) walks through every page with screenshots.

## Upgrade

Faucet keeps its config (databases, roles, keys) in its data directory, so upgrading keeps your setup. `faucet serve` runs in the background, so stop the old version first with `faucet stop`.

```bash
# npm: npx runs the latest release
npx @faucetdb/faucet@latest serve

# Homebrew
brew update && brew upgrade faucetdb/tap/faucet

# Docker (config persists in the faucet-data volume)
docker pull faucetdb/faucet:0.1.14
docker run -p 8080:8080 -v faucet-data:/data faucetdb/faucet:0.1.14

# Go
go install github.com/faucetdb/faucet/cmd/faucet@v0.1.14
```

Prebuilt binaries for Linux, macOS and Windows (amd64 and arm64) are on the [v0.1.14 release page](https://github.com/faucetdb/faucet/releases/tag/v0.1.14). Found a bug or a confusing screen? [Open an issue](https://github.com/faucetdb/faucet/issues).

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

[10 Best Database to REST API Tools in 2026 (Compared)](https://faucetdb.ai/blog/best-database-to-rest-api-tools/) (Oct 19, 2026): Ten tools that auto-generate a REST API from an existing SQL database, compared on databases, OpenAPI, MCP for AI agents, access control, license and pricing model.

[Best MCP Servers for Databases in 2026: 12 Compared](https://faucetdb.ai/blog/best-mcp-servers-for-databases/) (Oct 19, 2026): Twelve database MCP servers compared on databases, auth, read-only enforcement, audit, maturity, hosting and pricing model, with hands-on results for MCP Toolbox, DBHub and Faucet on the same SQLite fixture.

[MCP Server Security Checklist for Databases: 14 Controls](https://faucetdb.ai/blog/database-mcp-server-security-checklist/) (Oct 19, 2026): 14 security controls a database MCP server needs before an AI agent touches production data, scored on four servers we tested, ours included.
