Sql Query

🌐Community
by tatat Β· vlatest Β· Repository

Provides querying guidance and assistance for working with databases and data persistence.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add sql-query npx -- -y @trustedskills/sql-query
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "sql-query": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/sql-query"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill allows an AI agent to construct and execute SQL queries against a database. It can retrieve data, filter results based on specific criteria, and perform basic aggregations. The skill is designed to interact with relational databases using standard SQL syntax.

When to use it

  • Data Extraction: Retrieve specific information from a database for reporting or analysis (e.g., "Get me all orders placed last month").
  • Filtering Data: Narrow down results based on certain conditions (e.g., "Find customers who spent over $100").
  • Simple Aggregation: Calculate basic statistics like totals, averages, or counts from database tables (e.g., β€œWhat is the total revenue for each product category?”).
  • Data Validation: Check if specific data exists in a database and report back the findings.

Key capabilities

  • SQL query construction
  • Database interaction
  • Data retrieval
  • Filtering based on criteria
  • Basic aggregation functions

Example prompts

  • "Write a SQL query to find all customers from California."
  • "Can you get me the average order value?"
  • "Generate a query that lists products with a price greater than $50 and sort by name."

Tips & gotchas

The agent needs access to a database connection string or credentials to function. The skill's capabilities are limited to standard SQL; complex stored procedures or advanced features might not be supported.

Tags

πŸ›‘οΈ

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates β€” what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
tatat
Installs
11

🌐 Community

Passed automated security scans.