sql-expert

Design, query, optimize, and administer SQL databases across PostgreSQL, MySQL, and SQL Server.

Updated Mar 14, 2026

Search Tags:#query optimization #schema design #database #postgresql #sql #mysql

Ready to run

npx skills add https://github.com/MrAlexisCord/chatbot-prototype --skill sql-expert-mralexiscord

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-expert
Source: https://github.com/MrAlexisCord/chatbot-prototype/tree/main/.agents/skills/sql-expert
Command: npx skills add https://github.com/MrAlexisCord/chatbot-prototype --skill sql-expert-mralexiscord

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill empowers users to efficiently design, query, optimize, and administer SQL databases, ensuring data integrity and high performance.

Core Features & Use Cases

Database Design: Create robust, normalized schemas for various applications.
Advanced Querying: Write complex SQL queries using JOINs, subqueries, and window functions.
Performance Optimization: Implement indexing strategies and optimize query execution.
Transaction Management: Ensure data consistency through proper transaction control.
Use Case: A developer needs to design a new database schema for a social media platform, write efficient queries to retrieve user activity, and optimize them for speed.

Quick Start

Use the sql-expert skill to generate a PostgreSQL CREATE TABLE statement for a 'products' table with columns for id, name, price, and description.

Frequently Asked Questions about sql-expert

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

FAQPage Schema

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

To optimize slow SQL queries, apply indexing strategies and query execution analysis across PostgreSQL and MySQL. This Skill helps implement performance optimization techniques to reduce query latency and ensure efficient data retrieval.

What is the best way to design a normalized database schema for a new application?▼

The best way to design a normalized database schema is through systematic entity-relationship design. This Skill generates robust schemas that maintain data integrity across PostgreSQL, MySQL, and SQL Server for various application types.

Can I write complex SQL queries with window functions and subqueries using this tool?▼

Yes, you can write complex SQL queries using JOINs, subqueries, and window functions. This Skill provides advanced query writing capabilities to handle sophisticated data retrieval and aggregation logic across multiple database platforms.

Does this Skill support transaction control and stored procedures in SQL Server?▼

This Skill supports transaction control to ensure data consistency and handles advanced features like stored procedures and triggers. It provides expert administration for SQL Server, PostgreSQL, and MySQL environments.

Why does my database schema suffer from data anomalies and how can I fix them?▼

Database schemas suffer from data anomalies due to poor normalization and entity-relationship design. This Skill fixes them by enforcing normalization rules and generating robust schema structures that maintain strict data integrity.

When do I need to implement indexing strategies for database performance optimization?▼

You need to implement indexing strategies for database performance optimization when slow query execution impacts application responsiveness. This Skill analyzes query patterns and applies indexing techniques to boost retrieval speed.