Claude Skill

sql

Database query language.

LLM Mart · 0 points · 1 views 0 listing impressions 0 install-command copies
Download dhaupin-vant-models_public_vant_skills_vant-skill-sql-e1e348e.zip · 0 KB

Install

skills CLI npx skills add https://github.com/dhaupin/vant/tree/main/models/public/vant/skills/vant-skill-sql
Claude Code claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install dhaupin-vant@llmmart
Git git clone https://github.com/dhaupin/vant.git

The skills CLI installs just this skill, for any of its supported agents. Claude Code installs the whole dhaupin/vant collection as a plugin from our marketplace. Git is the plain clone.

Skill manifest

SQL

Database query language.


When To Use

  • Database queries
  • Data analysis
  • CRUD operations

What To Do

1. Basic

SELECT columns FROM table
WHERE condition
ORDER BY column
LIMIT n

2. Operations

Keyword What
SELECT Read
INSERT Create
UPDATE Update
DELETE Remove
JOIN Combine

3. Aggregates

SELECT COUNT(*), SUM(col), AVG(col), MIN(col), MAX(col)
FROM table
GROUP BY col
HAVING count > 1

4. Subqueries

SELECT * FROM users
WHERE id IN (SELECT user_id FROM orders)

Role: SQL Developer Input: Query Output: Results

Query.

Files (vant)
  • SKILL.md 784 B
    ---
    name: sql
    description: Database query language.
    license: MIT
    metadata:
      author: vant
      version: "1.0"
    ---
    
    # SQL
    
    > Database query language.
    
    ---
    
    ## When To Use
    
    - Database queries
    - Data analysis
    - CRUD operations
    
    ---
    
    ## What To Do
    
    ### 1. Basic
    
    ```sql
    SELECT columns FROM table
    WHERE condition
    ORDER BY column
    LIMIT n
    ```
    
    ### 2. Operations
    
    | Keyword | What |
    |---------|------|
    | SELECT | Read |
    | INSERT | Create |
    | UPDATE | Update |
    | DELETE | Remove |
    | JOIN | Combine |
    
    ### 3. Aggregates
    
    ```sql
    SELECT COUNT(*), SUM(col), AVG(col), MIN(col), MAX(col)
    FROM table
    GROUP BY col
    HAVING count > 1
    ```
    
    ### 4. Subqueries
    
    ```sql
    SELECT * FROM users
    WHERE id IN (SELECT user_id FROM orders)
    ```
    
    ---
    
    **Role**: SQL Developer **Input**: Query **Output**: Results
    
    > Query.

Comments (0)

Sign in to join the conversation.

No comments yet.

Reviews (0)

No reviews yet.