skills.rest
thepradip
thepradipCOMMUNITY
Explore all skills by this author →
GitHub

sql-analyst

Optimize SQL queries and schemas across PostgreSQL, MySQL, and SQLite.

Updated Mar 12, 2026
Search Tags:#postgresql#optimization#sql#data-analysis#mysql#schema-design#query-design
One-click install
npx skills add https://github.com/thepradip/openfangclaw --skill sql-analyst-thepradip
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-analyst
Source: https://github.com/thepradip/openfangclaw/tree/main/crates/openfang-skills/bundled/sql-analyst
Command: npx skills add https://github.com/thepradip/openfangclaw --skill sql-analyst-thepradip

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQL query optimization, schema design, and data analysis can be time-consuming and error-prone without a structured approach and best practices.

Core Features & Use Cases

  • Design efficient schemas and normalize data for analytics.
  • Optimize SQL queries across PostgreSQL, MySQL, SQLite, and other dialects.
  • Analyze data and generate insights with explain plans and performance considerations.

Quick Start

Provide a representative SQL task and context, and I will optimize the query, propose schema improvements, and explain the execution plan.

Frequently Asked Questions about sql-analyst

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

FAQPage Schema
How do I optimize SQL queries to improve database performance?▼

To optimize SQL queries, you analyze execution plans using EXPLAIN or EXPLAIN ANALYZE to identify bottlenecks, apply query tuning techniques, and plan indexes to improve overall database performance.

What is the best way to design a SQL schema for data analysis?▼

The best way to design a SQL schema for analytics is to normalize your data structures and apply safe handling of data types, which ensures efficient querying and accurate analytical insights.

Does SQL optimization work with both PostgreSQL and MySQL?▼

Yes, SQL optimization works with PostgreSQL, MySQL, and SQLite, applying query tuning, index planning, and schema improvements tailored to the specific dialect to boost analytical capability.

How do I use EXPLAIN ANALYZE to fix slow SQL query performance?▼

You use EXPLAIN ANALYZE to review the execution plan of slow SQL queries, revealing how indexes are used and where performance bottlenecks occur so you can apply targeted query tuning.

When do I need index planning for SQL database optimization?▼

You need index planning for SQL database optimization when query execution plans show full table scans or high latency, allowing you to strategically add indexes to improve data retrieval speed.

Related Skills

Explore More Data & Analytics Skills→
peterquielpeterquiel
4

database-schema

Extract PostgreSQL table definitions, columns, constraints, and indexes from a local database-schema.sql file.

Community
Intermediate
fatihkanfatihkan
7

data-analytics

Analyze datasets and generate analytics reports with visuals.

Community
Advanced
miles990miles990
20

data-design

Guide relational and NoSQL database schema design with normalization and pipeline patterns.

Community
Advanced
martiirivassmartiirivass

database

Design PostgreSQL and MongoDB schemas with constraints and optimized queries.

Community
Advanced