Skip to main content

Sql Database Assistant

Skill Verified Active

Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or SQLAlchemy.

Purpose

To empower users to efficiently manage and interact with SQL databases by providing expert-level assistance for query writing, performance tuning, schema management, and ORM integration.

Features

  • Natural Language to SQL translation
  • Schema exploration across multiple databases
  • SQL query optimization and analysis
  • Migration generation and rollback planning
  • ORM pattern examples and guidance
  • Multi-database dialect support

Use Cases

  • Writing complex SQL queries from natural language descriptions
  • Optimizing slow-running database queries
  • Generating SQL migration scripts for schema changes
  • Understanding and documenting existing database schemas
  • Implementing common ORM patterns and best practices

Non-Goals

  • Performing direct database administration tasks (e.g., backups, user management)
  • Replacing a full database management GUI
  • Writing application logic beyond ORM interaction patterns

Installation

First, add the marketplace

/plugin marketplace add alirezarezvani/claude-skills
/plugin install engineering@claude-code-skills

Quality Score

Verified
98 /100
Analyzed about 18 hours ago

Trust Signals

Last commitabout 21 hours ago
Stars14.6k
LicenseMIT
Status
View Source

Similar Extensions

Dsql

100

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

Skill
awslabs

Sql Optimization

100

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

Skill
github

MongoDB Connection Optimizer

100

Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.

Skill
mongodb

DBHub Database Query Guide

100

Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.

Skill
bytebase

Migrate Create

99

Create a new sequentially numbered database migration with up/down SQL files

Skill
ruvnet

Supabase Postgres Best Practices

99

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Skill
supabase

© 2025 SkillRepo · Find the right skill, skip the noise.