Blog

Faucet Blog

Updates, tutorials, and insights from the Faucet team.

Faucet Team

Your Indexes Matter 10x More Than Your Database — And MySQL Knew That All Along

We ran millions of MCP tool calls against PostgreSQL, MySQL, SQL Server, and SQLite and learned that indexing strategy matters 9-74x more than database choice. MySQL's defaults are already optimized and MCP protocol overhead is sub-millisecond.

benchmarkmcppostgresqlmysqlsql-serversqliteperformanceai-agents
Read more
Faucet Team

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, SQL Server, SQLite, and Snowflake with a single Faucet binary.

releaseannouncementv0.1.7oracle
Read more
Faucet Team

Faucet v0.1.6: Schema Contract Locking — Protect Your API from Silent Breaking Changes

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.

releaseannouncementv0.1.6schema-locking
Read more
Faucet Team

Faucet vs PostgREST: Which Database REST API Generator Should You Use in 2026?

An in-depth comparison of Faucet and PostgREST — two open-source tools that turn SQL databases into REST APIs. See how they compare on database support, auth, admin UI, and AI integration.

comparisonpostgrestrest-apidatabaseopen-source
Read more
Faucet Team

Faucet vs Supabase: Lightweight API Generator or Full Backend Platform?

A detailed comparison of Faucet and Supabase — two open-source tools for building APIs from databases. Compare database support, architecture, auth, pricing, and when each tool is the right choice.

comparisonsupabaserest-apidatabaseopen-sourcebaas
Read more
Faucet Team

How Faucet Turns Any Database Into a REST API — A Deep Technical Dive

28K lines of Go, 849 tests, zero CGO. Here's exactly how Faucet introspects your schema at runtime and serves a production-grade REST API without code generation.

engineeringarchitecturegodeep-dive
Read more
Faucet Team

Introducing Faucet: Turn Any SQL Database into a REST API

Faucet is an open-source, single-binary server that generates secure REST APIs from any SQL database. Here's why we built it and how it works.

announcementopen-sourcerelease
Read more
Faucet Team

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. Download now via Homebrew, Docker Hub, or GitHub Releases.

releaseannouncementv0.1.5
Read more