data-sql-optimization
🎯Skillfrom vasilyu1983/ai-agents-public
|Optimizes SQL queries by analyzing performance bottlenecks, recommending indexing strategies, and suggesting query restructuring for improved database efficiency.
Installation
npx skills add https://github.com/vasilyu1983/ai-agents-public --skill data-sql-optimizationSkill Details
Overview
# AI Agents Library
Production-Ready AI Agent Prompts & Claude Code Skills
A curated collection of 40+ Custom GPT agents and 50 Claude Code skills optimized for ChatGPT, Claude Projects, Codex, and Gemini platforms. [](https://opensource.org/licenses/MIT) [](./custom-gpt) [](./frameworks/claude-code-kit) [](CONTRIBUTING.md) [](https://twitter.com/vasilyu) [Quick Start](#-quick-start) • [Custom GPTs](#-custom-gpt-agents) • [Claude Skills](#-claude-code-skills) • [Frameworks](#-frameworks) • [Contributing](#-contributing)
---
Table of Contents
- [What's Inside](#whats-inside)
- [Repository Architecture](#repository-architecture)
- [Custom GPT Agents](#custom-gpt-agents)
- [Claude Code Skills](#claude-code-skills)
- [Frameworks](#frameworks)
- [Quick Start](#quick-start)
- [Prompt Engineering Framework](#prompt-engineering-framework)
- [Platform Support](#platform-support)
- [Contributing](#contributing)
- [License](#license)
What's Inside
This repository contains 40+ specialized AI agents and 50 Claude Code skills organized by domain, each optimized for specific tasks and workflows. All agents follow a consistent template structure with platform-specific optimizations.
```mermaid
graph TB
subgraph "AI Agents Library"
A[Custom GPT Agents
40+ Specialized Agents] --> A1[Education]
A --> A2[Lifestyle]
A --> A3[Productivity]
A --> A4[Programming]
A --> A5[Research & Analysis]
A --> A6[Writing]
B[Claude Code Skills
50 Development Skills] --> B1[Software Development]
B --> B2[AI/ML Engineering]
B --> B3[DevOps & Platform]
B --> B4[Quality & Testing]
B --> B5[Documentation]
C[Frameworks
Copy-Paste Ready] --> C1[Claude Code Kit]
C --> C2[Codex Kit]
C --> C3[Gemini Kit]
D[Master Template v3.5
13-Section Framework] --> A
D --> B
D --> C
end
style A fill:#4A90E2
style B fill:#9B59B6
style C fill:#E67E22
style D fill:#27AE60
```
What Makes This Different?
- Production-Ready: Every agent tested and optimized for real-world use
- Multi-Platform: Works across ChatGPT, Claude, Codex, and Gemini
- Systematic Framework: Master Template v3.5 with 13 standardized sections
- Character-Optimized: Custom GPT agents under 8000 char limit
- Curated Resources: JSON source files with 60+ curated references per domain
- Copy-Paste Kits: Complete
.claude/and.codex/workspace templates
Repository Architecture
```mermaid
graph LR
subgraph "Repository Structure"
A[custom-gpt/] --> A1[education/]
A --> A2[lifestyle/]
A --> A3[productivity/]
A --> A4[programming/]
A --> A5[research-n-analysis/]
A --> A6[writing/]
B[frameworks/] --> B1[claude-code-kit/
50 Skills]
B --> B2[codex-kit/
Router System]
B --> B3[gemini-kit/
Router System]
C[Each Agent] --> C1[01_agent-name.md
Main Prompt]
C --> C2[02_sources.json
Curated Resources]
C --> C3[agent-name.yaml
Configuration]
end
style A fill:#4A90E2,color:#fff
style B fill:#9B59B6,color:#fff
style C fill:#27AE60,color:#fff
```
Three-File Agent Pattern
Every agent follows a consistent structure:
```text
AgentName/
├── 01_agent-name.md # Main prompt file (<8000 chars for Custom GPT)
├── 02_sources-agent-name.json # Curated web resources and references
├── agent-name.yaml # Configuration (role, commands, constraints)
└── archive/
More from this repository10
product-management skill from vasilyu1983/ai-agents-public
Transforms raw data into actionable insights by automating complex data analysis workflows, performing statistical modeling, and generating comprehensive analytical reports using advanced engineeri...
Assists data scientists and machine learning engineers by providing automated code generation, model selection, preprocessing techniques, and data analysis workflows for AI and ML projects.
Routes and optimizes network configurations for complex engineering infrastructure, automating network topology design and performance analysis.
Provides reusable code hooks and lifecycle management utilities for streamlining Claude-based AI development workflows and code generation processes.
Based on the README, the "claude-code-skills" appears to be part of a collection of 50 development-focused Claude Code skills, specifically targeting software development, AI/ML engineering, DevOps...
Generates mobile software development workflows, code templates, and architectural guidance for cross-platform and native mobile application projects.
Generates comprehensive marketing content strategies by analyzing target audience, market trends, and business goals to create tailored content plans and recommendations.
Automates web application quality assurance testing using Playwright, generating comprehensive test scripts and executing cross-browser test scenarios with precision.
Based on the repository's overview and structure, I cannot definitively determine the specific functionality of the "project-qtax" Claude Code skill. The README provides a high-level description of...