ThinAir Data

- Multi-database— PostgreSQL, MySQL, SQL Server in a single session. Cross-database compare with one tool call.
- Read-only by design— SQL guards, database-session read-only mode where supported, and optional per-connection firewall rules.
- Dialect-aware— every tool understandsSELECT TOP 10(mssql) vsLIMIT(others) and routes syntax correctly per connection.
- Tiered capability— 26 tools across 4 tiers: schema introspection, query execution + history, EXPLAIN/optimization, anomaly detection, PII scanning, N+1 detection, query firewall, cross-DB compare, and runtime connection management (add/remove).
- Connections are managed at runtime— added per-tenant via theadd_connectiontool after sign-in. Never an env var or install-time config.

add_connection,remove_connection,optimize_query,explain_query,suggest_queries,generate_migration,generate_seed_data,watch_table,saved_queries,impact_analysis,configure_allowlist, and others round out the 26-tool surface.

Claude Desktop, Cursor, Windsurf — OAuth (recommended, keyless)

Add to your client's MCP config (e.g.~/Library/Application Support/Claude/claude_desktop_config.json):

{ "mcpServers": { "thinair-data": { "url": "https://data.thinair.co/mcp" } } }

The OAuth flow completes at first use — no manual token setup required. After sign-in, your agent callsadd_connectionto register a database with its DSN — connections are tenant-scoped and reusable across sessions.

{ "mcpServers": { "thinair-data": { "url": "https://data.thinair.co/mcp", "headers": { "Authorization": "Bearer ta_live_..." } } } }

Prints a config block to stdout. OAuth-keyless by default.

Database connections are added atruntimevia theadd_connectionMCP tool — pass the DSN once, the connection becomes a named resource the agent can reuse across sessions. Three dialects supported:

You donotput a DSN in your client's config. Theadd_connectiontool is how connections enter the session.

- "Show me all rows that haven’t updated in the last 24 hours across staging and prod"
- "What are the top 10 slowest queries this week?"
- "Scan the customers table for PII patterns"
- "Which tables have the most N+1 query exposure?"

Do not commit DSNs, passwords, tokens, private keys, or production credentials. Use OAuth, the hosted connection flow, or your MCP client's secret storage.

Previously published asthinair-data(now deprecated in favor of the scoped package).

Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety

A read-only MCP server by CData that enables LLMs to query live data from EnterpriseDB databases.

A read-only MCP server for MySQL, enabling LLMs to query live data using the CData JDBC Driver.

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.

Update various databases (PostgreSQL, MySQL, MongoDB, SQLite) using data from CSV and Excel files.

Expert-level PostgreSQL database analysis MCP server for AI assistants.

Enables AI assistants to interact with various databases through JDBC connections.