SkillsAdd

smithery/pluginagentmarketplace

databases-sql

SQL database querying, optimization, and data management for analytics

Installation

$ npx skills add smithery/pluginagentmarketplace --skill databases-sql
View on skills.sh ↗ Website ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

supabase-postgres-best-practices Shared topics
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-cli Shared topics
prisma/skills

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, …

267K installs
supabase Shared topics
supabase/agent-skills

Use when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge F…

263K installs
neon-postgres Shared topics
neondatabase/agent-skills

>- Guides and best practices for working with Lakebase Postgres, the database behind Neon. Cove…

146.5K installs
firebase-data-connect Shared topics
firebase/agent-skills 142.2K installs
flutter-working-with-databases Similar name
flutter/agent-plugins

Manages local data persistence using SQLite or other database solutions. Use when a Flutter app…

8.6K installs

Also in this package

Other skills from smithery/pluginagentmarketplace · top by installs.

npx skills add smithery/pluginagentmarketplace
vue-testing 0 vue-router 0 vue-fundamentals 0 user-guides 0 uikit-development 0 tutorials-samples 0 time-series 0 thought-leadership 0 text-processing 0 terraform-state 0

Browse all from smithery/pluginagentmarketplace

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Also listed on

Alternate registries and mirrors of this skill.

Skill metadata

Parsed from SKILL.md frontmatter.

Version2.0.0

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 2,420 B
  • docs SUMMARY.md 91 B

History

  1. First recorded snapshot · 0 installs

SKILL.md

Databases & SQL Skill

Overview

Master SQL and database concepts essential for data analysts, from basic queries to advanced optimization and data warehousing.

Core Topics

SQL Fundamentals

  • SELECT, FROM, WHERE, ORDER BY
  • JOINs (INNER, LEFT, RIGHT, FULL)
  • GROUP BY and aggregate functions
  • Subqueries and CTEs

Advanced SQL

  • Window functions (ROW_NUMBER, RANK, LAG, LEAD)
  • Recursive queries
  • Query optimization and execution plans
  • Index strategies

Database Concepts

  • Relational database design principles
  • Normalization and denormalization
  • Data warehousing concepts (star schema, snowflake)
  • ETL processes

Popular Platforms

  • PostgreSQL
  • MySQL
  • SQL Server
  • BigQuery, Redshift, Snowflake

Learning Objectives

  • Write efficient SQL queries for data extraction
  • Understand database design and optimization
  • Work with cloud data warehouses
  • Implement ETL processes for analytics pipelines

Error Handling

Error Type Cause Recovery
Syntax error Invalid SQL Validate query syntax before execution
Timeout Long-running query Add indexes, optimize query
Connection failed Network/auth issue Retry with exponential backoff
Permission denied Access rights Request appropriate permissions
Deadlock Concurrent transactions Retry transaction

Related Skills

  • foundations (for data concepts)
  • programming (for SQL with Python/R)
  • advanced (for big data processing)