Skip to content
MCP server

Faucet

Single-binary Go gateway that exposes SQL databases as a REST API and MCP tools

Install
Pricing
Open source
Platforms
self-hosted, CLI, API
Runs
Locally or Remotely
Version
0.1.15
Listing updated
1 day ago

About Faucet

Faucet is an open-source MCP server for databases. It can run locally on your machine or as a hosted remote server.

Faucet is a single Go binary released under the MIT licence. It introspects a connected database and generates REST endpoints, an OpenAPI 3.1 spec and MCP tools at runtime, with no code generation or ORM. PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake and SQLite are supported.

The MCP server sits at /mcp on the same port as the REST API and uses Streamable HTTP. Agents authenticate with an API key in the X-API-Key header, and the key's role decides which databases and tables they can see and change, exactly as for the REST API. A stdio mode is also published on npm and runs with local admin rights.

The docs include ready-made connection steps for Claude Code, Cursor, VS Code, Windsurf and Claude Desktop (through mcp-remote). ChatGPT connectors need OAuth, which Faucet does not offer yet, so the docs route ChatGPT through a custom GPT action or the OpenAI Responses API instead.

Install

Run in a terminal

claude mcp add faucet -- npx -y @faucetdb/faucet

Add to claude_desktop_config.json

{
  "mcpServers": {
    "faucet": {
      "command": "npx",
      "args": [
        "-y",
        "@faucetdb/faucet"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "faucet": {
      "command": "npx",
      "args": [
        "-y",
        "@faucetdb/faucet"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "faucet": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@faucetdb/faucet"
      ]
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "faucet": {
      "command": "npx",
      "args": [
        "-y",
        "@faucetdb/faucet"
      ]
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "faucet": {
      "command": "npx",
      "args": [
        "-y",
        "@faucetdb/faucet"
      ]
    }
  }
}

Configuration

  • FAUCET_DATA_DIRFaucet data directory holding the databases you connected with `faucet serve` or `faucet db add`. Default: ~/.faucet. stdio mode runs with local admin rights.

What it does

Runtime-generated tools
MCP tools, REST endpoints and OpenAPI docs are built from the live database schema.
Role-based access
API key roles limit which databases and tables an agent can read or change.
Many SQL engines
Connects to PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake and SQLite.
Built-in HTTP endpoint
Streamable HTTP MCP is served at /mcp alongside the REST API, with no extra process.
Admin UI
An embedded admin UI creates API keys and shows per-client MCP configs.

Good for

  • Give an AI assistant governed read/write access to a company database
  • Put a REST API in front of a legacy SQL Server or MySQL database
  • Query several databases through one gateway
  • Generate an OpenAPI spec for an existing schema

Pricing

Open source

MIT licensed; self-hosted

Prices change. Check wiki.faucetdb.ai before you buy.

Faucet FAQ

How do agents authenticate to Faucet's MCP server?

They send an API key in the X-API-Key header. The key's role decides which databases and tables they can access; an admin session token also works but bypasses roles.

Which databases does it support?

PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, Snowflake and SQLite.

Can ChatGPT connect to it?

Not through a ChatGPT connector, because Faucet does not offer OAuth yet. The docs describe a custom GPT action or the OpenAI Responses API, and Faucet must be reachable from the internet.

Is it open source?

Yes, the README describes it as an MIT-licensed single Go binary.

Is Faucet free?

Yes. Faucet is open source, so you can use and self-host it for free.

How do I add Faucet to Claude Code?

Run this command in your terminal: claude mcp add faucet -- npx -y @faucetdb/faucet

What are the best alternatives to Faucet?

The closest alternatives to Faucet are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

Alternatives to Faucet

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  3. GitHub

    MCP server

    Official MCP server connecting AI assistants to GitHub repos, issues and workflows

    Not checked yet
    • Remote
    • Open source
    • 34.5K GitHub stars
    • Developer tools
  4. MCP toolkit giving coding agents symbol-level code retrieval and editing

    Runs locally
    • Open source
    • 31.5K GitHub stars
    • Developer tools
  5. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  6. Ouroboros

    MCP server

    Spec-first layer that pins requirements and verifies results of AI coding agent work

    Runs locally
    • Open source
    • 6.4K GitHub stars
    • Developer tools