ThinAir Data
Read-only MCP server for PostgreSQL, MySQL, and SQL Server with schema introspection, SQL query execution, EXPLAIN/optimization, anomaly detection, PII scanning, and N+1 query detection.
ThinAir Data MCP Server
Connect your AI assistant to any PostgreSQL, MySQL, or SQL Server database in 60 seconds via MCP.
What It Does
ThinAir Data is a Model Context Protocol (MCP) server that gives AI agents secure, read-only access to your databases — no custom backend required. SELECT / WITH / EXPLAIN are permitted; INSERT / UPDATE / DELETE / DROP / ALTER are blocked at the query firewall.
- Multi-database — PostgreSQL, MySQL, SQL Server
- Read-only by design — write statements rejected before they hit your DB; safe to point any agent at production
- Secure — OAuth 2.1 + API key auth, query sandboxing, per-tenant connection pooling
- AI-ready — Schema introspection, dialect-aware tools, natural language to SQL
Product Links
- Main: https://data.thinair.co
- Connect a database: https://data.thinair.co/connect
- Docs: https://data.thinair.co/docs/getting-started
- Pricing: https://data.thinair.co/checkout
Tools
| Tool | Description |
|---|---|
query | Execute a SQL query and return results |
list_tables | List all tables in the database |
describe_table | Get schema and column details for a table |
list_databases | List available databases/schemas |
execute | Run INSERT, UPDATE, DELETE statements |
Quick Start
Claude Desktop
Add to ~/Library/Application Support/Claude/claude_desktop_config.json:
{
"mcpServers": {
"thinair-data": {
"command": "npx",
"args": ["-y", "@thinairtelematics/data"],
"env": {
"THINAIR_API_KEY": "your-api-key",
"DATABASE_URL": "postgresql://user:pass@host:5432/dbname"
}
}
}
}
Cursor / Windsurf / Other MCP Clients
{
"mcpServers": {
"thinair-data": {
"command": "npx",
"args": ["-y", "@thinairtelematics/data"],
"env": {
"THINAIR_API_KEY": "your-api-key",
"DATABASE_URL": "postgresql://user:pass@host:5432/dbname"
}
}
}
}
Remote / Streamable HTTP
{
"mcpServers": {
"thinair-data": {
"type": "http",
"url": "https://data.thinair.co/mcp",
"headers": {
"Authorization": "Bearer your-api-key"
}
}
}
}
Supported Databases
| Database | Connection String Format |
|---|---|
| PostgreSQL | postgresql://user:pass@host:5432/db |
| MySQL | mysql://user:pass@host:3306/db |
| SQL Server | sqlserver://user:pass@host:1433/db |
Example Usage
Once connected, ask your AI:
- "Show me all vehicles that haven’t pinged in the last 24 hours"
- "What are the top 10 routes by mileage this month?"
- "List all open maintenance tickets ordered by priority"
- "How many active drivers do we have per region?"
npm Package
npmjs.com/package/@thinairtelematics/data
Previously published as
thinair-data(now deprecated in favor of the scoped package).
License
MIT © ThinAir Telematics
関連サーバー
MySQL
Interact with and manage MySQL databases. Requires connection details configured via environment variables.
Federal Reserve Economic Data
Access financial datasets from the Federal Reserve Economic Data (FRED) API.
Tableau MCP Server
Interact with Tableau Server using natural language to query data and perform administrative tasks.
TalkHub Store
Integrates with Supabase to allow AI assistants to access and manage store data.
AlphaFold MCP Server
Access the AlphaFold Protein Structure Database for protein structure prediction and analysis.
AWS RDS Management
Manage Amazon RDS and Aurora database clusters, including instances, backups, parameters, costs, and monitoring.
FRED Economic Data
Access economic data from the Federal Reserve Bank of St. Louis (FRED).
MOTE Registry
Search the MOTE AI agent registry to discover machine-readable businesses by category, location, and keyword
Power BI MCP Servers
Integrate with Power BI using a local server for offline .pbix file analysis and an Azure server for querying live datasets.
Redshift MCP Server
An MCP server for Amazon Redshift, allowing AI assistants to interact with Redshift databases.