Database Query OptimizerAI database optimizer
Analyzes slow queries, designs schemas, and fixes database performance issues.
What This Skill Does
Paste your slow SQL queries, schema, or EXPLAIN output and get back optimized queries with detailed explanations of why they're faster. It analyzes indexing strategy, identifies N+1 patterns, rewrites subqueries, suggests schema changes, and explains execution plans in plain English. Supports PostgreSQL, MySQL, and SQLite.
Who Should Use This
- Backend developers with slow queries
- DBAs optimizing production databases
- Data engineers designing schemas
- Full-stack developers learning database performance
Common Use Cases
- Analyze and optimize slow SQL queries
- Design efficient database schemas
- Suggest proper indexing strategies
- Debug query execution plans
- Migrate between database systems
- Optimize N+1 queries and join strategies
How It Works on OpenClaw
- 1
Install the skill
Browse the marketplace, pick a skill, and add it to your assistant with one click.
- 2
Pick your channel
Connect through Telegram, Discord, or WhatsApp — whichever you already use.
- 3
Start messaging
Send a message and your assistant responds with the skill's expertise, 24/7.
Best Channels and Models
Best Channels
Best Models
Limitations
- Cannot connect to your database directly
- Cannot run queries or test optimizations
- Always test optimization suggestions in a staging environment first
Not Suitable For
- DBAs needing an AI that connects to and runs queries on live databases
- Teams requiring automated database monitoring and alerting
- Organizations needing managed database administration services
Example Interaction
You
This query takes 12 seconds on our users table with 2M rows: SELECT * FROM users WHERE email LIKE '%@gmail.com' ORDER BY created_at DESC LIMIT 50.
Database Query Optimizer
The LIKE with a leading wildcard ('%@gmail.com') prevents index usage — it's doing a full table scan on 2M rows. Three options: (1) Add a functional index on the email domain: CREATE INDEX idx_email_domain ON users (split_part(email, '@', 2)). (2) If you query by domain often, add a separate email_domain column with an index. (3) Use pg_trgm extension with a GIN index for pattern matching. Option 2 is fastest for this specific query.
Setup Requirements
- OpenClaw account
- Discord or Telegram
- Your slow query, EXPLAIN output, and table schema
Frequently Asked Questions
What databases does it support?
PostgreSQL, MySQL, SQLite, MongoDB, Redis, and most popular databases. It adapts optimization advice to the specific database engine you're using.
Can it analyze EXPLAIN output?
Yes. Paste your query and its EXPLAIN/ANALYZE output, and it identifies bottlenecks and suggests specific optimizations.
Does it help with ORMs?
Yes. Paste ORM-generated queries (Prisma, Sequelize, SQLAlchemy, etc.) and it can suggest both query-level and ORM-level optimizations.
Related Skills
Ready to try Database Query Optimizer?
Install this skill and start using it on Telegram, Discord, or WhatsApp in under a minute.