# Faucet v0.1.7: Oracle Support — 7 Databases, One Binary

> Faucet v0.1.7 adds Oracle 12c–26ai support with a pure-Go driver, no Instant Client. Seven databases, one binary: Postgres, MySQL, MariaDB and more.

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

Faucet Team · March 2, 2026 · Updated October 8, 2026 · 4 min read

**Faucet v0.1.7: Oracle Database Support — 7 Databases, One Binary**

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.

Tags: release, announcement, v0.1.7, oracle

Faucet v0.1.7 is now available. The headline feature: **full Oracle Database support** — from Oracle 12c all the way through Oracle AI Database 26ai, using a pure-Go driver with zero native dependencies. Download it now from [GitHub Releases](https://github.com/faucetdb/faucet/releases/tag/v0.1.7), [Homebrew](https://github.com/faucetdb/homebrew-tap), or [Docker Hub](https://hub.docker.com/r/faucetdb/faucet).

## Why Oracle?

Oracle Database powers a massive share of enterprise workloads. Teams running Oracle alongside PostgreSQL or MySQL have had to maintain separate API layers or resort to hand-written middleware. With v0.1.7, Faucet connects to Oracle the same way it connects to everything else: point it at a DSN, get a REST API.

This brings Faucet to **7 supported database engines** — PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, and Snowflake — all from a single binary.

## What’s Included

### Full CRUD + Filtering

Every feature that works with PostgreSQL or MySQL now works with Oracle:

- **GET** with filtering, sorting, pagination (`OFFSET/FETCH NEXT`)
- **POST** single and bulk insert (`INSERT ALL`)
- **PUT/PATCH** with conditional updates
- **DELETE** with filter predicates
- **Stored procedures** — call PL/SQL procedures via the REST API

### Pure-Go Driver

Faucet uses [go-ora](https://github.com/sijms/go-ora), a pure-Go Oracle driver. This means:

- **No Oracle Instant Client.** No `LD_LIBRARY_PATH`. No `.so` files. No CGO.
- **Cross-platform.** The same Faucet binary runs on Linux (amd64/arm64), macOS (Intel/Apple Silicon), and Windows.
- **Docker-friendly.** No Oracle libraries to bundle into your container. The existing `faucetdb/faucet` image just works.

### Schema Introspection

Faucet reads Oracle’s catalog views (`ALL_TABLES`, `ALL_TAB_COLUMNS`, `ALL_CONSTRAINTS`, `ALL_CONS_COLUMNS`) to discover your schema automatically. Primary keys, foreign keys, nullable columns, data types — all introspected and exposed in the OpenAPI spec.

### Oracle-Native SQL

The query builder generates Oracle-idiomatic SQL:

- **Bind parameters:** `:1`, `:2`, `:3` (not `$1` or `?`)
- **Pagination:** `OFFSET n ROWS FETCH NEXT m ROWS ONLY` (Oracle 12c+)
- **Bulk insert:** `INSERT ALL INTO ... INTO ... SELECT 1 FROM DUAL`
- **Stored procedures:** `BEGIN schema.procedure(:1, :2); END;`

### Cloud Compatibility

Works with:

- **Oracle Cloud Infrastructure (OCI)** — Autonomous Database, Base Database Service
- **Amazon RDS for Oracle**
- **Azure Database** — Oracle workloads on Azure VMs

## Quick Start

```bash
# Install or upgrade
brew update && brew upgrade faucet

# Add an Oracle connection
faucet db add --name myoracle --driver oracle \
  --dsn "oracle://user:pass@localhost:1521/XEPDB1"

# Start serving
faucet serve

# Create a read-only key and query a table
faucet role create --name reader --verbs GET
faucet key create --role reader
curl -H "X-API-Key: faucet_YOUR_KEY" "http://localhost:8080/api/v1/myoracle/_table/EMPLOYEES?limit=10"
```

Your Oracle tables are now available at `http://localhost:8080/api/v1/myoracle/_table/`. Full walkthrough: [Oracle tutorial](https://wiki.faucetdb.ai/tutorial-oracle).

### Supported Versions

| Version | Status |
| --- | --- |
| Oracle 12c (12.1, 12.2) | Supported |
| Oracle 18c | Supported |
| Oracle 19c | Supported |
| Oracle 21c | Supported |
| Oracle 23ai | Supported |
| **Oracle 26ai** | **Supported** |

Oracle AI Database 26ai, Oracle’s latest release, is fully supported. The `go-ora` driver is compatible with all Oracle Database versions from 12c onward.

## Also in This Release

- **SQLite version coverage** updated through 3.52 (released March 1, 2026)
- **Database count** corrected to 7 across all documentation and marketing materials

## Install or Upgrade

**Homebrew:**

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

**Docker:**

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

**Go install:**

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

**Binary download:**

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

## What’s Next

With 7 database engines covered, the focus shifts to the features that make multi-database deployments production-ready:

- **Cross-database joins** — query across Oracle and PostgreSQL in a single request
- **Oracle-aware MCP hints** — Oracle already works with the standard `faucet_*` MCP tools; next up is richer Oracle-specific type and schema hints for agents
- **Advanced PL/SQL support** — function return values, `OUT` parameters, and cursor-based result sets

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.6?

Run `brew upgrade faucet` or `docker pull faucetdb/faucet:0.1.7`. Binary users can download the new release from GitHub. No config migration needed — just add your Oracle connection.

### Do I need Oracle Instant Client?

No. Faucet uses a pure-Go driver (`go-ora`) that speaks the Oracle Net Protocol directly. No native libraries, no CGO, no Instant Client.

### Does Oracle support schema contract locking?

Yes. The schema locking feature introduced in v0.1.6 works with Oracle connections. Lock, diff, and promote Oracle schema contracts the same way you would with PostgreSQL or MySQL.

### What Oracle authentication methods are supported?

Username/password via the Oracle DSN. Wallet-based authentication and Oracle Cloud IAM token auth are on the roadmap.

### Can I connect to Oracle Autonomous Database on OCI?

Yes. Use the standard Oracle connection string with your wallet credentials. Faucet connects through the `go-ora` driver, which supports OCI connectivity.

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

[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/) (Oct 19, 2026): Step-by-step SQL to create a read-only database user for an AI agent on PostgreSQL, MySQL/MariaDB, SQL Server, Oracle, Snowflake and SQLite, how to add read-only enforcement in the MCP or REST layer, and how to prove it by attempting a write.

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

[Faucet v0.1.5 Released: First-Run Setup, Batch Transactions, and Background Mode](https://faucetdb.ai/blog/faucet-v015-release/) (Feb 24, 2026): Faucet v0.1.5 introduces guided first-run setup, batch transaction modes, background server mode, and improved telemetry controls.
