ThinAir Data

httpnonedatabase

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.

github ↗

Install

How to run this server

[ { "cmd": "npx -y @thinairtelematics/data", "imports": [] } ]

server path: thinair-data

Tools

What this server exposes

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)

Configuration

Environment & auth

authnone

Resources

githubhttps://github.com/ThinAirTelematics/thinair-data ↗