MCP servers for databases and data
Last verified: 2026-09
A database MCP is SQL or an API with your credentials. There is no extra permission layer in the protocol. If the role can DROP TABLE, the model can too. The first install should be a read-only user on a copy or a dev instance — not the production owner URL from your password manager.
What to look for
- Create a read-only role before you paste a URL into mcp.json.
- SQLite: give the model a copy of the file. Postgres/MySQL: GRANT SELECT only.
- Warehouse servers (Snowflake, BigQuery) cost money per query. Cap the warehouse size.
Side-by-side
| Server | Official? | Needs a secret? | Best for |
|---|---|---|---|
| PostgreSQL | Yes | Yes | Run SQL against a Postgres database. |
| SQLite | Yes | No | Query a local SQLite file. |
| Redis | Yes | Yes | Get and set keys in Redis. |
| MongoDB | No | Yes | Query MongoDB collections. |
| MySQL | No | Yes | Query MySQL or MariaDB. |
| Elasticsearch | No | Yes | Search an Elasticsearch cluster. |
| Snowflake | No | Yes | Run SQL on Snowflake. |
| BigQuery | No | Yes | Query Google BigQuery datasets. |
| Neon | No | Yes | Manage and query Neon Postgres. |
| Supabase | No | Yes | Talk to a Supabase project: tables, auth, edge functions. |
| Airtable | No | Yes | Read and write Airtable bases. |
All 11 servers
OfficialPostgreSQLRun SQL against a Postgres database.
OfficialSQLiteQuery a local SQLite file.
OfficialRedisGet and set keys in Redis.
Databases & dataMongoDBQuery MongoDB collections.
Databases & dataMySQLQuery MySQL or MariaDB.
Databases & dataElasticsearchSearch an Elasticsearch cluster.
Databases & dataSnowflakeRun SQL on Snowflake.
Databases & dataBigQueryQuery Google BigQuery datasets.
Databases & dataNeonManage and query Neon Postgres.
Databases & dataSupabaseTalk to a Supabase project: tables, auth, edge functions.
Databases & dataAirtableRead and write Airtable bases.
FAQ
Is Postgres safer than SQLite?
No. Safety is the role, not the engine. A read-only Postgres user is safer than a writable SQLite file.
Should I connect production?
Not to a general-purpose chat. Use a replica or a redacted dump.
Neon or Supabase vs raw Postgres?
Use the vendor server if you also need branches and project admin. Use Postgres if you only need SQL.