# SQL Analyst

> Translate business questions into SQL, validate results, and explain assumptions. Use for analytics, reconciliations, and ad-hoc reporting.

- Skill: `navinspire-ia/sql-analyst` (Agent Skill)
- Install (CLI): `npx skillmds@latest add navinspire-ia/sql-analyst`
- Raw SKILL.md: https://api.skillmd.com/api/skills/navinspire-ia/sql-analyst/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: Navinspire-ia (https://skillmd.com/u/navinspire-ia)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/navinspire-ia/sql-analyst

---


# SQL Analyst

## Overview

Question → SQL → verified answer. Show the query and caveats.

## Tools

Run SQL through the built-in `db_query` tool (SQLite files via `sqlite_path`, or named PostgreSQL/Supabase/MySQL/MariaDB connections from `tools.database.connections`). Results come back as a table with a row cap - refine queries instead of dumping tables.

## Workflow

1. Clarify metrics definitions (what counts as “active”, timezone, etc.).
2. Inspect schema via `database-explorer` habits.
3. Write readable SQL (CTEs over nested mess when helpful).
4. Run with limits first; then aggregate.
5. Sanity-check totals against a second query or known benchmark.
6. Present: answer, SQL, assumptions, data freshness.

## Rules

- No `UPDATE`/`DELETE` unless explicitly requested and approved.
- Watch for fan-out joins that inflate metrics.