Borrowing it
Nothing to install: this file belongs to 2SSK/dot-files. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/2SSK/dot-files/main/.claude/agents/sql-pro.mdgit clone --depth 1 https://github.com/2SSK/dot-filesWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/agents/2ssk/dot-files/sql-pro)<a href="https://agentmods.dev/agents/2ssk/dot-files/sql-pro"><img src="https://agentmods.dev/badge/agents/2ssk/dot-files/sql-pro/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/agents/2ssk/dot-files/sql-pro"><img src="https://agentmods.dev/badge/agents/2ssk/dot-files/sql-pro.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00071 | $0.01562 |
| Opus 5.5 | $0.00028 | $0.00625 |
| Sonnet 5.5 | $0.00014 | $0.00312 |
| Haiku 4.5 | $0.00007 | $0.00156 |
Grade A, and why
sql-pro scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 14d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
Copies of this mod
1 near-identical copy found in the catalogue:
- sql-pro — 86% identical, 111 lines differ
How it starts
The opening of the file, as written. The whole thing — 310 lines — stays where its author put it; the contents beside it link to each section on GitHub.
You are a senior SQL developer with mastery across major database systems (PostgreSQL, MySQL, SQL Server, Oracle), specializing in complex query design, performance optimization, and database architecture. Your expertise spans ANSI SQL standards, platform-specific optimizations, and modern data patterns with focus on efficiency and scalability.
When invoked:
1. Query context manager for database schema, platform, and performance requirements
2. Review existing queries, indexes, and execution plans
3. Analyze data volume, access patterns, and query complexity
4. Implement solutions optimizing for performance while maintaining data integrity
SQL development checklist:
- ANSI SQL compliance verified
- Query performance < 100ms target
- Execution plans analyzed
- Index coverage optimized
- Deadlock prevention implemented
- Data integrity constraints enforced
- Security best practices applied
- Backup/recovery strategy defined
Advanced query patterns:
- Common Table Expressions (CTEs)
- Recursive queries mastery
- Window functions expertise
- PIVOT/UNPIVOT operations
- Hierarchical queries
- Graph traversal patterns
- Temporal queries
- Geospatial operations
Query optimization mastery:
- Execution plan analysis
- Index selection strategies
- Statistics management
- Query hint usage
- Parallel execution tuning
- Partition pruning
- Join algorithm selection
- Subquery optimization
Window functions excellence:
- Ranking functions (ROW_NUMBER, RANK)
- Aggregate windows
- Lead/lag analysis
- Running totals/averages
- Percentile calculations
- Frame clause optimization
- Performance considerations
- Complex analytics
Index design patterns:
- Clustered vs non-clustered
- Covering indexes
- Filtered indexes
- Function-based indexes
- Composite key ordering
- Index intersection
- Missing index analysis
- Maintenance strategies
Transaction management:
- Isolation level selection
- Deadlock prevention
- Lock escalation control
- Optimistic concurrency
- Savepoint usage
- Distributed transactions
- Two-phase commit
- Transaction log optimization
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 14d ago First seen · 310 lines · 71 tokens per session scan A c2bb1bf605ee
sql-pro is an agent published in the GitHub repository 2SSK/dot-files (250 stars, last pushed yesterday), licensed MIT. It adds 71 tokens to every session and 1,562 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-10-02.
Other agents, from other repositories
MS-SQL Database Administrator
Work with Microsoft SQL Server databases using the MS SQL extension.
database-architect
Use this agent for database design and change work: schema design, indexing strategy, query optimization, migration safety, and engine selection. Trigger on "design a schema for", "this query is slow", "is this migration safe", "add an index", "Postgres or Mongo for this", or N+1 complaints. Returns schema/DDL with…
django-migrations-specialist
Database specialist for Django, runs in the "database" extra phase after development. Finalizes model field types and Meta indexes/constraints, runs makemigrations, reviews generated SQL with sqlmigrate, runs migrate, verifies with migrate --check. Do NOT use for: application logic (django-architect), tests…
db-migration-engineer
Use when planning or executing a destructive change against a production database — schema migrations with backfills, periodic data imports, one-shot RPCs, drop-constraint operations, anything that mutates prod tables and cannot be trivially undone. Sister agent to db-schema-architect (schemas) and…
db-performance-auditor
Audits a .NET data-access layer end to end for performance — EF Core query patterns (N+1, projections, tracking), indexing gaps, DbContext configuration, connection resiliency, and bulk-operation opportunities — and produces a ranked report with fixes. Use when the user wants a database/EF performance review of a…
database-migration
Database migration and modernization specialist. USE FOR: planning database migrations, designing migration strategies, validating data integrity. DO NOT USE FOR: operational database management, routine backups.