# Faucet v0.1.5: First-Run Setup, Batch Modes, Background

> Faucet v0.1.5 adds guided first-run setup, batch transaction modes (rollback or continue), background server mode, and friendlier telemetry opt-out.

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

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

**Faucet v0.1.5 Released: First-Run Setup, Batch Transactions, and Background Mode**

Faucet v0.1.5 introduces guided first-run setup, batch transaction modes, background server mode, and improved telemetry controls.

Tags: release, announcement, v0.1.5

Faucet v0.1.5 is now available. This release focuses on developer experience — making it easier to get started, run in production, and handle bulk writes. Download it now from [GitHub Releases](https://github.com/faucetdb/faucet/releases/tag/v0.1.5), [Homebrew](https://github.com/faucetdb/homebrew-tap), or [Docker Hub](https://hub.docker.com/r/faucetdb/faucet).

## What’s New in v0.1.5

### Guided First-Run Setup

The most-requested improvement since launch: Faucet now detects when it’s running for the first time and walks you through creating your initial admin account interactively. No more digging through docs to figure out the right CLI commands. Just run `faucet serve` and follow the prompts.

This lowers the barrier from “read the docs, then configure” to “just run it.”

### Batch Transaction Modes

Write operations now support two transaction modes for bulk inserts and updates:

- **Rollback mode** — all-or-nothing. If any row fails, the entire batch rolls back. Use this when data consistency matters more than throughput.
- **Continue mode** — best-effort. Failures on individual rows are recorded but don’t block the rest of the batch. Use this for bulk imports where partial success is acceptable.

Set the mode per request with the `?rollback=true` or `?continue=true` query parameter. The default behavior remains unchanged — single-row operations are unaffected.

```bash
curl -X POST -H "X-API-Key: faucet_YOUR_KEY" -H "Content-Type: application/json" \
  "http://localhost:8080/api/v1/mydb/_table/users?rollback=true" \
  -d '{"resource": [{"name": "Ada"}, {"name": "Grace"}]}'
```

### Background Server Mode

`faucet serve` now returns control to your terminal immediately, running the API server in the background. This makes it trivial to integrate Faucet into shell scripts, CI pipelines, and systemd services without process management wrappers.

```bash
faucet serve
# Faucet is running in the background — your terminal is free
curl -H "X-API-Key: faucet_YOUR_KEY" "http://localhost:8080/api/v1/mydb/_table/users?limit=10"
```

Need it attached to the terminal (Docker, systemd)? Use `faucet serve --foreground`.

### Improved Telemetry Controls

Opting out of anonymous telemetry is now more forgiving. The `FAUCET_TELEMETRY` environment variable accepts case-insensitive values and recognizes `no`, `false`, `0`, and `off`. Previously, only exact lowercase matches worked.

```bash
export FAUCET_TELEMETRY=no   # works now
export FAUCET_TELEMETRY=NO   # also works now
```

### Code Quality

Under the hood, v0.1.5 includes multiple lint fixes — particularly around deferred error handling in transaction rollbacks. These don’t change behavior but improve correctness guarantees and keep the codebase ready for production use.

## Install or Upgrade

**Homebrew:**

```bash
brew update && brew upgrade faucet
```

**Docker:**

```bash
docker pull faucetdb/faucet:0.1.5
```

**Go install:**

```bash
go install github.com/faucetdb/faucet/cmd/faucet@v0.1.5
```

**Binary download:**

Grab the binary for your platform from [GitHub Releases](https://github.com/faucetdb/faucet/releases/tag/v0.1.5). Available for Linux (amd64, arm64), macOS (Apple Silicon, Intel), and Windows.

## What’s Next

Faucet is still in early development and we’re shipping fast. Here’s what’s on the roadmap for upcoming releases:

- **Column-level filtering** — restrict which columns are exposed per role (not yet shipped)
- **Rate limiting** — built-in request throttling per API key (not yet shipped)
- **Webhook support** — push notifications on data changes (not yet shipped)
- **Enhanced MCP tools** — richer schema introspection for AI agents

Star the project on [GitHub](https://github.com/faucetdb/faucet) to follow along, and [open an issue](https://github.com/faucetdb/faucet/issues) if you run into anything.

## FAQ

### How do I upgrade from v0.1.4?

Run `brew upgrade faucet` or `docker pull faucetdb/faucet:0.1.5`. Binary users can download the new release from GitHub. No database migrations are needed — v0.1.5 is fully backward compatible with v0.1.4 configurations.

### Does the first-run setup change anything for existing installations?

No. The setup flow only triggers when Faucet detects no existing admin account. If you already have one configured, startup behavior is identical to v0.1.4.

### Is batch transaction mode available for all databases?

Yes. Both rollback and continue modes work across PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, and Snowflake.

### Can I still run Faucet in the foreground?

Yes. `faucet serve` runs in the background by default; add `--foreground` to keep it attached to your terminal (the right choice for Docker and systemd). `faucet status` and `faucet stop` manage the background server.

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

[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.

[Faucet v0.1.6: Schema Contract Locking — Protect Your API from Silent Breaking Changes](https://faucetdb.ai/blog/faucet-v016-release/) (Feb 26, 2026): Faucet v0.1.6 introduces schema contract locking, a system that prevents database schema changes from silently breaking your auto-generated REST API. Lock your API contract, detect drift, and promote changes on your terms.

[Introducing Faucet: Turn Your SQL Database into a REST API](https://faucetdb.ai/blog/introducing-faucet/) (Feb 24, 2026): 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.
