Query databases with SSH tunnel
db-queryskillsetup L2★9
Demerzels-lab/elsamultiskillagent ↗What it does
Write and optimize database queries
Best for
Finding slow queries and writing efficient SQL.
Inputs
- · Query
- · Schema
- · Data sample
Outputs
- · Optimized SQL
- · Execution plan
Requires
- · Database client
- · Query optimizer
Preconditions
Database access; schema knowledge.
Failure modes
Query plan assumptions break with data scale; index hints ignored.
Trust signals
- · Query plans from actual DB engines
- · EXPLAIN output parsed
- · Cost-based optimization