ThinAir Data (verified)
Connect AI assistants to PostgreSQL, MySQL, or SQL Server in 60 seconds. 24 dialect-aware tools — query, schema introspection, anomaly detection, query optimization. Read-only at three layers (firewa…
Quick Start
# Connect this server (installs CLI if needed)
npx -y smithery mcp add thinair/data
# Browse available tools
npx -y smithery tool list thinair/data
# Get full schema for a tool
npx -y smithery tool get thinair/data query_sql
# Call a tool
npx -y smithery tool call thinair/data query_sql '{}'Direct MCP Connection
Endpoint: https://thinair-data.run.tools
Tools (23)
query_sql— Execute a read-only SQL query against the target connection. ONLY SELECT / WITH / EXPLAIN permitted. Write dialect-appr…describe_schema— Discover the full database schema: tables, columns, types, primary keys, foreign keys, and indexes. Results cached 1 ho…analyze_table— QUICK statistical snapshot for ONE table — row count, null rates, cardinality, numeric min/max/avg, date ranges. Option…detect_anomalies— Scan a table for unusual patterns: volume drops/spikes, data gaps, value concentration, high null rates, stale data. Se…suggest_queries— Generate schema-aware query suggestions with ready-to-run SQL. Great for exploring unfamiliar databases or finding usef…test_connection— Ping a connection (SELECT 1) and return server version + latency. Fast way to confirm credentials and network path with…list_connections— List every database connection registered for your tenant: name, id, dbType (postgres / mysql / mssql), createdAt. Flag…quota— Check current API usage, daily limit, plan name, and upgrade options.issue_api_key— Issue a fresh ta_data_* API key for your current tenant. Useful for pasting into /add-database or configuring a separat…explain_query— Analyze a SQL query's execution plan and return plain-English performance recommendations. Runs EXPLAIN ANALYZE (Postgr…optimize_query— Suggest a rewritten, optimized version of a SQL query with explanations. Identifies sequential scans, missing indexes, …data_profile— FULL data quality + compliance report for a table: per-column stats PLUS a 0-100 health score, type-gated PII detection…query_history— Return recent queries executed through ThinAir with timing, row counts, and status. [BUILD tier]saved_queries— Manage your personal library of reusable SELECT queries. action=save stores a query by name; action=run executes a save…generate_migration— Generate dialect-correct ALTER TABLE migration SQL + rollback from a plain-English intent. Output uses the connection's…generate_seed_data— Generate realistic, schema-aware INSERT statements for development and testing. Respects types, constraints, and FK rel…show_locks— List active sessions + blocking locks. Uses the dialect's own system view —pg_stat_activityon postgres, `informatio…pii_scan— Sweep string columns across tables for common PII patterns (email, SSN, credit card, phone, JWT, bearer tokens). Heuris…watch_table— Monitor a table's row count and latest record. Compares to previous snapshot to show changes. Built-in scheduler. [ARCH…find_n_plus_one— Detect N+1 query patterns from recent query history. Fingerprints queries and flags repeated patterns. [ARCHITECT tier]query_firewall— Manage per-connection SQL rules: block dangerous patterns, require WHERE on large tables, log PII access. [ARCHITECT ti…impact_analysis— Analyze the blast radius of a proposed schema change: FK dependencies, affected views, row count, risk score. [ARCHITEC…cross_db_query— ⚠️ SQL MUST BE VALID IN EVERY DIALECT YOU TARGET — stick to ANSI-ish SELECT syntax when mixing pg/mysql/mssql. `SELECT …
# Get full input/output schema for a tool
npx -y smithery tool get thinair/data