# Faucet

> Faucet is an open-source MCP server for databases. Single-binary Go gateway that exposes SQL databases as a REST API and MCP tools. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** self-hosted, CLI, API
- **Website:** https://wiki.faucetdb.ai/mcp-server
- **Repository:** https://github.com/faucetdb/faucet
- **MCP Registry name:** io.github.faucetdb/faucet
- **Categories:** databases, developer tools
- **Listing updated:** 2026-11-15

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

### Cursor (~/.cursor/mcp.json)

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

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "faucet": {
      "command": "npx",
      "args": [
        "-y",
        "@faucetdb/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

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.

---
Source: https://ai-powered.com/mcp/faucet
