# SQL

> SQL database queries, joins, aggregations, subqueries, and optimization. Use for .sql files and database operations. Use when this capability is needed.

- Skill: `tomevault-io/sql-3` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add tomevault-io/sql-3`
- Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/sql-3/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: tomevault-io (https://skillmd.com/u/tomevault-io)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/tomevault-io/sql-3

---


# 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

```sql
-- 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', 'alice@example.com');

-- 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](https://www.postgresql.org/docs/)

---
> Source: [G1Joshi/Agent-Skills](https://github.com/G1Joshi/Agent-Skills) — distributed by [TomeVault](https://tomevault.io).
<!-- tomevault:4.0:skill_md:2026-05-22 -->