ThinAir Data
JSON →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.
Install
npx -y @thinairtelematics/data Tools · 10
- list_connections List connected databases with names + dialects
- describe_schema Get schema, columns, indexes, FKs across any connection
- query_sql Execute a parameterized read-only SQL query
- query_history Recent queries with timing, row counts, status
- data_profile Distributions, null rates, cardinality on a table
- cross_db_query Run the same query across 2–4 connections (regional/dialect compare)
- detect_anomalies Statistical outliers in row growth, latency, value distributions
- pii_scan Scan a table for PII patterns (SSN, email, phone, credit card)
- find_n_plus_one Identify N+1 query patterns in query_history
- query_firewall Per-connection custom-block rules (deny specific tables/queries)