# Connect ChatGPT to Your SQL Database

> Let ChatGPT query your PostgreSQL, MySQL, SQL Server or other SQL database through a Custom GPT Action or the Responses API, with a read-only Faucet API key.

Source: https://faucetdb.ai/connect-chatgpt-to-database/

Guide · OpenAPI · MCP

**Connect ChatGPT to your database**

Run Faucet next to your database, create a read-only API key, and expose Faucet over HTTPS. Then either add a Custom GPT Action that imports `https://your-host/openapi.json` with the key in an `X-API-Key` header, or, from your own code, pass Faucet's `/mcp` endpoint as an MCP tool to the OpenAI Responses API. ChatGPT connectors need OAuth, which Faucet doesn't offer yet.

Updated October 9, 2026 for Faucet v0.1.14

## Two routes that work today

| Route | Best for | What ChatGPT uses |
| --- | --- | --- |
| **Custom GPT Action** | Using your data in the ChatGPT app | Faucet’s REST API, described by `/openapi.json` |
| **Responses API MCP tool** | Your own app or agent built on the OpenAI API | Faucet’s MCP endpoint, `/mcp` |

Both need a URL OpenAI’s servers can reach, so the setup starts the same way.

## 1\. Connect your database to Faucet

```
npx @faucetdb/faucet serve
```

Open `http://localhost:8080`, create an admin account, and add your database with its host, port, database, username and password. **Test connection** checks it before you save. Setup guides: [PostgreSQL](https://wiki.faucetdb.ai/tutorial-postgres), [MySQL and MariaDB](https://wiki.faucetdb.ai/tutorial-mysql), [SQL Server](https://wiki.faucetdb.ai/tutorial-sqlserver), [Oracle](https://wiki.faucetdb.ai/tutorial-oracle), [SQLite](https://wiki.faucetdb.ai/tutorial-sqlite), [Snowflake](https://wiki.faucetdb.ai/tutorial-snowflake).

## 2\. Create a read-only key

```
faucet role create --name chatgpt-readonly --verbs GET --service mydb
faucet key create --role chatgpt-readonly --label chatgpt   # prints the key once
```

Or create a **Read only** role and a key in the admin UI. Leave raw SQL off for any database ChatGPT can reach.

## 3\. Expose Faucet over HTTPS

Expose Faucet, never the database port. Pick one:

- **Reverse proxy:** nginx or Caddy in front of Faucet with a TLS certificate.
- **Cloudflare Tunnel:** `cloudflared tunnel --url http://localhost:8080` prints a temporary `https://` URL for testing.
- **ngrok:** `ngrok http 8080` prints a public `https://` URL.

Check it from outside your network:

```
curl https://your-host/healthz
curl "https://your-host/api/v1/mydb/_table?limit=5" -H "X-API-Key: faucet_YOUR_KEY"
```

## 4a. Custom GPT Action

1. Create a GPT and add an **Action**.
2. Import the schema from `https://your-host/openapi.json`. Faucet generates this OpenAPI 3.1 spec from your live schema.
3. Set authentication to **API key**, auth type **Custom**, header name `X-API-Key`, and paste your key.

The GPT can then call endpoints such as `GET /api/v1/mydb/_table/orders?filter=status = 'open'&limit=25`. Filters work like a SQL `WHERE` clause and are always sent as bound parameters.

## 4b. OpenAI Responses API

If you build on the OpenAI API, pass Faucet as an MCP tool in the `tools` array:

```
{
  "type": "mcp",
  "server_label": "faucet",
  "server_url": "https://your-host/mcp",
  "headers": { "X-API-Key": "faucet_YOUR_KEY" },
  "require_approval": "never"
}
```

The model can then call Faucet’s tools, such as `faucet_list_tables`, `faucet_describe_table` and `faucet_query`, limited by the key’s role. Drop `require_approval` if you want to approve calls yourself.

![Faucet API explorer building a GET request on the orders table with a filter of status = shipped and a limit of 3](https://faucetdb.ai/screenshots/api-explorer-1200.webp)

_The API explorer builds and sends REST requests, then copies them as curl, JavaScript or Python._

Before handing a key to ChatGPT, the admin UI’s API explorer can send requests _as that key_, so you see exactly what it can read.

## Why not a ChatGPT connector?

ChatGPT connectors authenticate with OAuth. Faucet’s REST API and MCP endpoint use API keys and Faucet doesn’t offer OAuth yet, so a connector can’t sign in. The two routes above send the key as a header instead.

## Frequently asked questions

### Can I add Faucet as a ChatGPT connector?

Not today. ChatGPT connectors sign in with OAuth, and Faucet authenticates with API keys and does not offer OAuth yet. A Custom GPT Action (using Faucet's OpenAPI spec) or the OpenAI Responses API's MCP tool works instead.

### Does my database have to be on the internet?

No. Only Faucet has to be reachable over HTTPS, because OpenAI calls it from its own servers. Run Faucet next to the database and expose Faucet with a reverse proxy, Cloudflare Tunnel or ngrok. The database port stays private.

### Which key should ChatGPT get?

Its own key, bound to a role that only grants GET on the tables it needs. Faucet denies anything a role doesn't grant, and you can revoke the key at any time without affecting other apps.

### Can ChatGPT see every row in a table it can read?

Yes. Faucet's roles work per database, table and verb. Row-level filters are stored but not enforced yet, and there are no column-level permissions, so to share part of a table, expose a database view instead.

### Does this work for my Postgres database? What about SQL Server or Oracle?

Yes. The same steps work for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite and Snowflake, because ChatGPT only ever talks to Faucet's REST API or MCP endpoint.

## Related

- [Connect Claude to a database](https://faucetdb.ai/connect-claude-to-database/) Claude Code and Claude Desktop over MCP, no public URL needed.
- [PostgreSQL REST API and MCP server](https://faucetdb.ai/postgresql-rest-api/) Connect Postgres, query it over REST, filters and examples.
- [SQL Server REST API and MCP server](https://faucetdb.ai/sql-server-rest-api/) Put an on-prem SQL Server behind a REST API.
- [MCP server docs](https://wiki.faucetdb.ai/mcp-server) The /mcp endpoint, tools and the Responses API example.
- [Deployment docs](https://wiki.faucetdb.ai/deployment) TLS, reverse proxies and a production checklist.

## Try it on your own database

Free, MIT-licensed, no account needed.

`npx @faucetdb/faucet serve`

or `brew install faucetdb/tap/faucet` · `docker run -p 8080:8080 -v faucet-data:/data faucetdb/faucet`

[Star on GitHub](https://github.com/faucetdb/faucet) [Getting started](https://wiki.faucetdb.ai/getting-started)

Faucet is independent and not affiliated with or endorsed by the companies whose products are named on this page. Spot something out of date? [Open an issue](https://github.com/faucetdb/faucet/issues).
