skills.rest
XSpoonAi
XSpoonAiOFFICIAL
Explore all skills by this author →
WebsiteGitHub

Database Operations Manager

Analyze SQL/NoSQL queries and generate optimization recommendations with structured JSON output.

17|45|Updated Jan 23, 2026
Search Tags:#performance#database#optimization#sql#nosql#analyze#cost-estimation
One-click install
npx skills add https://github.com/XSpoonAi/spoon-awesome-skill --skill database-operations-manager
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Operations Manager
Source: https://github.com/XSpoonAi/spoon-awesome-skill/tree/main/ai-productivity/database-operations
Command: npx skills add https://github.com/XSpoonAi/spoon-awesome-skill --skill database-operations-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

AI-powered DB optimization helps teams reduce query costs, speed up workloads, and improve data integrity by analyzing queries, validating schemas, and tuning configurations.

Core Features & Use Cases

  • Query Analysis & Optimization: Analyzes SQL/NoSQL queries and suggests improvements.
  • Schema Validation: Checks normalization, primary/foreign keys, constraints.
  • Index Recommendation: Suggests indexes to improve performance.
  • Connection Pool Management: Configures and tunes connection pools.
  • Performance Metrics: Estimates costs and execution plans.

Quick Start

Analyze the following SQL/NoSQL query and return an optimized plan with index recommendations and cost estimates.

Frequently Asked Questions about Database Operations Manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries in MySQL and PostgreSQL?▼

To optimize slow SQL queries, you analyze the query input and table statistics to generate an optimized query plan with index recommendations. This process improves execution speed and reduces operational costs across MySQL, PostgreSQL, MariaDB, and SQLite.

Can I analyze and tune NoSQL workloads in MongoDB?▼

Yes, you can analyze and tune NoSQL workloads in MongoDB. The system accepts query inputs and table statistics for MongoDB, returning structured JSON with optimized queries, health metrics, and index recommendations to improve workload performance.

What is the best way to validate database schema design and constraints?▼

Validating database schema design involves checking normalization, primary keys, foreign keys, and constraints to ensure data integrity. This analysis identifies structural inefficiencies and provides recommendations to improve overall database health and performance.

How do I estimate query costs and execution plans?▼

Estimating query costs requires analyzing the original query input against table statistics and the specified optimization level. The system calculates performance metrics and returns structured JSON containing health metrics and cost estimates for the execution plan.

Does this database optimization approach work for transactional and reporting tasks?▼

Yes, this database optimization approach works for transactional, analytics, and reporting tasks. It applies across multiple database types including MySQL, PostgreSQL, MariaDB, SQLite, and MongoDB to analyze workloads and generate performance tuning recommendations.

Related Skills

Explore More Data & Analytics Skills→
starlake-aistarlake-ai
209

bq-info

Retrieve BigQuery table schemas, metadata, and properties across datasets and projects.

Official
Intermediate
lagarcesslagarcess
1

supabase-postgres-best-practices

Optimize Supabase Postgres queries and schemas with SQL rewrites and EXPLAIN-based diagnosis.

Community
Advanced
liuridaliurida

gorm-prometheus

Expose GORM database metrics to Prometheus for monitoring.

Community
Advanced
laurigateslaurigates
10

Infrastructure Terraform

Automate cloud infrastructure provisioning with Terraform and HCL.

Community
Advanced