Sql

Skill G1Joshi/Agent-Skills/skills/languages/sql

A comprehensive skill catalog for AI agents

Install

npx -y skills add G1Joshi/Agent-Skills --skill sql

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

10 stars10 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

SQL database queries, joins, aggregations, subqueries, and optimization. Use for .sql files and database operations.

SKILL.md

1.4 KB, 300 tokens by cl100k_base, as published. Nobody here has run it

SQL

Standard language for storing, manipulating and retrieving data in databases.

When to Use

Relational data modeling
Complex queries and aggregations
Data integrity enforcement (ACID)
Standardized data access

Quick Start

-- Create Table
CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100) UNIQUE
);

-- Insert Data
INSERT INTO users (name, email) VALUES ('Alice', '[email protected]');

-- Query Data
SELECT * FROM users WHERE name = 'Alice';

Core Concepts

DDL (Data Definition Language)

Commands to define database schemas (CREATE, ALTER, DROP).

DML (Data Manipulation Language)

Commands to manipulate data (SELECT, INSERT, UPDATE, DELETE).

Joins

Combining rows from two or more tables based on a related column.

INNER JOIN: Matches in both tables.
LEFT JOIN: All from left, matches from right.

Best Practices

Do:

Use parameterized queries (prevent SQL Injection)
Index columns used in WHERE and JOIN clauses
Use transactions for atomic operations

Don't:

Use SELECT * in production (fetch only what you need)
Store logic in triggers if possible (hard to debug)
Ignore execution plans for slow queries

References

PostgreSQL Documentation