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.

npm version License: MIT smithery badge

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

Tools

ToolDescription
queryExecute a SQL query and return results
list_tablesList all tables in the database
describe_tableGet schema and column details for a table
list_databasesList available databases/schemas
executeRun 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

DatabaseConnection String Format
PostgreSQLpostgresql://user:pass@host:5432/db
MySQLmysql://user:pass@host:3306/db
SQL Serversqlserver://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

NotebookLM Web Importer

Importez des pages web et des vidéos YouTube dans NotebookLM en un clic. Utilisé par plus de 200 000 utilisateurs.

Installer l'extension Chrome