Deploy Now

Stars

170

Forks

22

Watchers

3

Developer links

Faucet

One binary and one command is all it takes: the SQL database you already run gains a secure REST API and MCP server, with no code generation and no ORM boilerplate. Point it at PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake, or SQLite and it introspects the schema at runtime, generating full CRUD endpoints with filtering, ordering, and pagination plus a live OpenAPI 3.1 specification. The embedded admin UI connects databases with plain host, port, user, and password fields, tests the connection before saving, and tells you exactly what to fix when it fails. You browse tables, columns, keys, and data, build roles with per-table verb permissions, and issue API keys that are SHA-256 hashed with a role assigned to each. Schema contract locking watches for drift that would silently break your API, with none, auto, and strict modes managed from the UI or CLI. The API explorer builds filtered, paginated requests and copies them out as curl, JavaScript, or Python. An MCP server on the same port gives Claude Code, Cursor, VS Code, Windsurf, and other AI tools governed access to your data under exactly the same roles and keys as any API client. Legacy databases such as SQL Server 2012 or PostgreSQL 9.6 gain a modern API without code changes or migration. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. MIT licensed.

Faucet
Faucet
Faucet
Faucet
Faucet

Benefits

  • API Without Writing One
  • Point Faucet at an existing database and its schema becomes full CRUD endpoints with filtering, ordering, pagination, and a live OpenAPI 3.1 specification in under a minute.
  • Seven Databases, One Gateway
  • PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake, and SQLite all connect to a single instance, including cloud variants such as RDS, Aurora, Supabase, and Neon.
  • Governed Access by Role
  • Per-table verb permissions, SHA-256 hashed API keys with assigned roles, and JWT admin sessions decide exactly who can read or write every table you expose.
  • Agents Obey the Same Rules
  • The built-in MCP server serves AI tools through the same roles and API keys as human clients, so governed database access extends to agents without a second policy.

Features

  • Runtime Schema Introspection
  • Tables, columns, types, constraints, and stored procedures are discovered live, with DDL available through the API and no code generation step to maintain.
  • Schema Contract Locking
  • Lock the API contract against breaking schema changes with none, auto, or strict modes, drift detection in the admin UI, and CLI management commands.
  • Embedded Admin UI
  • Connect databases by host and port with a pre-save connection test, browse schemas and data, manage roles and keys, and copy MCP configs, all offline-capable.
  • Built-In API Explorer
  • Compose filtered and paginated requests visually, inspect the JSON response, and copy the result as curl, JavaScript, or Python for immediate use elsewhere.
  • Health Probes Included
  • The /healthz and /readyz endpoints support Kubernetes-style liveness and readiness checks, and all configuration lives in a local SQLite store with no external dependency.

Apps Similar to Faucet