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
Serveurs connexes
Microsoft Access Database
Allows AI to interact with Microsoft Access databases, supporting data import and export via CSV files.
USDA Nutrition MCP Server
Access nutrition information for over 600,000 foods from the USDA FoodData Central database.
MongoDB Mongoose MCP
An MCP server for MongoDB with optional Mongoose schema support.
MCP Knowledge Graph
Provides persistent memory for AI models using a local knowledge graph.
TalkHub Store
Integrates with Supabase to allow AI assistants to access and manage store data.
Redis MCP Server
A natural language interface for agentic applications to manage and search data in Redis.
MCP MariaDB Server
Manage and query MariaDB databases using the Model Context Protocol (MCP), with support for SQL and vector search.
IMF Data MCP
Retrieve and process economic data from the International Monetary Fund (IMF) API, including datasets, time series, indicators, and countries.
MCP Variance Log
Logs statistical variations and unusual events in conversation structures to a SQLite database.
Nile Postgres
Manage and query databases, tenants, users, auth using LLMs