skills.rest
gil-kapel
gil-kapelCOMMUNITY
Explore all skills by this author →
GitHub

SQL

Design schemas, write queries, and migrate across SQL platforms.

2|1|Updated Apr 1, 2026
Search Tags:#performance#database#migration#sql#query#relational
One-click install
npx skills add https://github.com/gil-kapel/cursor-course-2026 --skill sql-gil-kapel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: SQL
Source: https://github.com/gil-kapel/cursor-course-2026/tree/main/course/he_course/module-02-skills-and-agents/lesson-2.5-tech-lead-architecture/bundled-skills/sql-openclaw
Command: npx skills add https://github.com/gil-kapel/cursor-course-2026 --skill sql-gil-kapel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, mysql-connector-python, sqlite3, pyodbc, and includes references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps users understand and implement relational database management, enabling optimized data storage, querying, and maintenance.

Core Features & Use Cases

  • Relational Database Operations: Design schemas, write queries, and perform migrations across PostgreSQL, MySQL, SQLite, and SQL Server.
  • Performance Optimization: Use indexing, explain plans, and transaction management to improve database efficiency.
  • Use Case: A developer needs to set up a multi-tenant application with clean audit logs and data integrity, ensuring reliable and scalable database operations.

Quick Start

Use the sql skill to establish connection to a local PostgreSQL database and run a sample query.

Frequently Asked Questions about SQL

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

FAQPage Schema
How do I write efficient SQL queries for a relational database?▼

Efficient SQL queries require proper indexing, analyzing explain plans, and managing transactions. This involves schema design and performance tuning to optimize data retrieval across PostgreSQL, MySQL, SQLite, and SQL Server.

What is the best way to handle database migrations safely?▼

Safe database migrations require structured transaction handling and backup strategies for production environments. This ensures data integrity is maintained during schema changes across supported relational platforms.

Does this SQL skill work with both PostgreSQL and MySQL?▼

Yes, it supports PostgreSQL and MySQL, alongside SQLite and SQL Server. It provides comprehensive relational database operations, query writing, and schema design capabilities across these specific platforms.

How do I design a relational database schema for a multi-tenant application?▼

Designing a multi-tenant schema requires clean audit logs and strict data integrity. This involves structured schema design and reliable transaction management to ensure scalable database operations.

Why is query performance tuning important for relational databases?▼

Query performance tuning improves database efficiency by using indexing and explain plans. It prevents bottlenecks during data retrieval and ensures reliable operations in production environments.

Related Skills

Explore More Software Engineering Skills→
Shamrock2245Shamrock2245
1

connecting-streamlit-to-snowflake

Establishes Snowflake database connections from Streamlit apps using st.connection and session writes.

Community
Intermediate
eddiegenteddiegent

job-stats

Analyze job application history and export statistics to CSV, JSON, or Markdown.

Community
Intermediate
silaslopes100silaslopes100

reversa-data-master

Generate data dictionaries and ERD diagrams from DDL, migrations, and ORM models.

Community
Advanced
snoodleboot-iosnoodleboot-io
2

nosql-database-selection

Assess application requirements and recommend suitable NoSQL database types.

Official
Intermediate