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
Related Servers
Chroma MCP Server
An MCP server for the Chroma embedding database, providing persistent, searchable working memory for AI-assisted development with features like automated context recall and codebase indexing.
MCP Memory libSQL
A persistent memory system for MCP using libSQL, providing vector search and efficient knowledge storage.
Microsoft Fabric Analytics
An analytics server providing tools for interacting with the Microsoft Fabric data platform.
Memento MCP
A scalable knowledge graph memory system for LLMs with semantic retrieval and temporal awareness, using Neo4j as a backend.
MCP Memory Server
An advanced memory system for Claude Desktop that provides persistent memory using MCP. Requires an Azure Cosmos DB account and an OpenAI API key.
COTI Blockchain MCP
Interact with the COTI blockchain for private token and NFT operations, including ERC20 and ERC721, with privacy features.
Apple Health Data with Elasticsearch
A Python-based MCP server that connects to an Elasticsearch index with Apple HealthKit data.
GreptimeDB
Provides AI assistants with a secure and structured way to explore and analyze data in GreptimeDB.
VictoriaMetrics
A server for writing and querying time series data using the VictoriaMetrics API.
IGDB MCP Server
Access the IGDB (Internet Game Database) API through Model Context Protocol (MCP)