Skip to main content
skillsmp

菜单

SQL 数据库

浏览 MySQL、PostgreSQL 和 SQL 数据库管理的 agent skills

分类、GitHub Stars 和来源更新时间只用于组织与排序目录，不代表 SkillsMP 背书、质量认证、安全审核或适用性保证。使用前请进入详情页检查来源。

13,875 个结果

postgres-patterns
253.2k
affaan-maffaan-m/ECC
Patrones de base de datos PostgreSQL para optimización de consultas, diseño de esquemas, indexación y seguridad. Basado en las buenas prácticas de Supabase.

Skill 内容语言： 西班牙语

postgres-patterns
253.2k
affaan-maffaan-m/ECC
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Skill 内容语言： 日语

postgres-patterns
253.2k
affaan-maffaan-m/ECC
쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Skill 内容语言： 韩语

postgres-patterns
253.2k
affaan-maffaan-m/ECC
Sorgu optimizasyonu, şema tasarımı, indeksleme ve güvenlik için PostgreSQL veritabanı kalıpları. Supabase en iyi uygulamalarına dayanır.

Skill 内容语言： 土耳其语

postgres-patterns
253.2k
affaan-maffaan-m/ECC
用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。
postgres-patterns
253.2k
affaan-maffaan-m/ECC
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
database-migrations
253.2k
affaan-maffaan-m/ECC
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Skill 内容语言： 英语

postgres-patterns
253.2k
affaan-maffaan-m/ECC
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Skill 内容语言： 英语

database-migrations
253.2k
affaan-maffaan-m/ECC
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate). Use when writing a schema or data migration, planning a rollback, or aiming for zero-downtime deployment.

Skill 内容语言： 英语

mysql-patterns
253.2k
affaan-maffaan-m/ECC
MySQL and MariaDB schema, query, indexing, transaction, replication, and connection-pool patterns for production backends. Use when designing MySQL or MariaDB schemas and indexes, or when a query, transaction, or replica lags.

Skill 内容语言： 英语

postgres-patterns
253.2k
affaan-maffaan-m/ECC
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices. Use when designing PostgreSQL schemas, indexes, or RLS policies, or when a query is too slow.

Skill 内容语言： 英语

safe-sql-execution
108.9k
supabasesupabase/supabase
Use whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix and never says "security," "injection," or "SafeSqlFragment." This covers: writing or editing any pg-meta function, query builder, or endpoint that builds/returns SQL for database objects (tables, views, functions, DB triggers, indexes, RLS policies); interpolating a schema/table/column/search/route-param value into SQL text; storing, fetching, or re-running SQL that round-trips from the database (a policy's definition, a function/view definition, a snippet's saved content); and any "Run"/"Apply"/"Execute" action that sends SQL to a project's database (SQL editor run-selection, policy editor apply, snippet runner). Load this BEFORE writing such code, not only when reviewing a finished diff. Skip only for changes that never touch SQL text or execution — styling, unrelated data hooks, non-SQL form validation, or UI layout work.

Skill 内容语言： 英语

drizzle
82.3k
lobehublobehub/lobehub
Use for Drizzle schemas and queries: tables, indexes, relations, joins and inferred types. Rollout belongs to db-migrations.

Skill 内容语言： 英语

migrate-create
71.6k
ruvnetruvnet/ruflo
Create a new sequentially numbered database migration with up/down SQL files

Skill 内容语言： 英语

create-database-migration
55.2k
TryGhostTryGhost/Ghost
Create a database migration to add a table, add columns to an existing table, add a setting, or otherwise change the schema of Ghost's MySQL database. Use this skill whenever the task involves modifying Ghost's database schema — including adding, removing, or renaming columns or tables, adding new settings, creating indexes, updating data, or any change that requires a migration file in ghost/core. Also use when the user references schema.js, knex-migrator, the migrations directory, or asks to "add a field" or "add a column" to any Ghost model/table. Even if the user frames it as a feature or Linear issue, if the implementation requires a schema change, this skill applies.

Skill 内容语言： 英语

transforms
49.2k
metabasemetabase/metabase
Authoring transforms with transform_write — the query source (definition vs query_handle), the target table and what patching it renames, why the target database is never yours to choose, the two shapes the tool refuses (python, incremental), tags and folders. Read before your first transform_write. Triggers — "make a transform", "materialize this query into a table", "build a table other questions can query", "rename a transform's output table", "why won't it let me edit this transform".

Skill 内容语言： 英语

sql-reporting
46.8k
apacheapache/airflow
Conventions and review steps for writing analytics SQL against the warehouse. Use whenever the task involves querying tables, building a report, or aggregating metrics.

Skill 内容语言： 英语

querying-local-postgres
39.6k
PostHogPostHog/posthog
Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT). Default local URL postgres://posthog:posthog@localhost:5432/posthog; else DATABASE_URL. Use when querying the local DB, inspecting tables, debugging data, or analyzing query plans. Mutations are strictly forbidden.

Skill 内容语言： 英语

writing-clickhouse-queries
39.6k
PostHogPostHog/posthog
Guide for writing performant ClickHouse queries in PostHog product code. Use when writing HogQL query runners, designing a ClickHouse table for a new product, adding materialized columns or skip indexes, or choosing a row ID format. For optimizing an existing query that is already too slow, use `/optimizing-clickhouse-and-hogql-queries` instead.

Skill 内容语言： 英语

setting-up-a-data-warehouse-source
39.6k
PostHogPostHog/posthog
Guide the user through connecting a new data warehouse source — Postgres, MySQL, Stripe, Hubspot, MongoDB, Salesforce, BigQuery, Snowflake, and so on. Use when the user wants to "connect Stripe", "import data from Postgres", "add a new data source", "sync my warehouse tables", or wants to pick sync methods for each table. Walks through source-type discovery, credential validation, table discovery, per-table sync_type selection, and the final create call. Also covers picking a good prefix and what to do right after creation.

Skill 内容语言： 英语

tuning-incremental-sync-config
39.6k
PostHogPostHog/posthog
Change the sync configuration of an existing data warehouse schema — switch sync_type, pick a different incremental_field, set primary_key_columns, choose cdc_table_mode, or change sync_frequency. Use when the user asks "switch my orders table from full refresh to incremental", "this table is syncing too slowly / too frequently", "I need to pick a different incremental column", "set up CDC for this Postgres table", or when diagnosis of a failing sync pointed to an incremental-field or PK misconfiguration.

Skill 内容语言： 英语

postgresql-table-design
39.5k
wshobsonwshobson/agents
Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Skill 内容语言： 英语

sql-optimization-patterns
39.5k
wshobsonwshobson/agents
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

Skill 内容语言： 英语

creating-oracle-to-postgres-migration-bug-report
38.8k
githubgithub/awesome-copilot
Creates structured bug reports for defects found during Oracle-to-PostgreSQL migration. Use when documenting behavioral differences between Oracle and PostgreSQL as actionable bug reports with severity, root cause, and remediation steps.

Skill 内容语言： 英语

migrating-oracle-to-postgres-stored-procedures
38.8k
githubgithub/awesome-copilot
Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies explicit collation mapping (`COLLATE "C"` only when appropriate, locale collations when required). Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.

Skill 内容语言： 英语

postgresql-code-review
38.8k
githubgithub/awesome-copilot
PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).

Skill 内容语言： 英语

postgresql-optimization
38.8k
githubgithub/awesome-copilot
PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem.

Skill 内容语言： 英语

reviewing-oracle-to-postgres-migration
38.8k
githubgithub/awesome-copilot
Identifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting/collations, UNION ALL planner risks, materialized-view refresh requirements, timestamps, concurrent transactions, etc.). Use when planning a database migration, reviewing migration artifacts, or validating that integration tests cover Oracle/PostgreSQL differences.

Skill 内容语言： 英语

sql-code-review
38.8k
githubgithub/awesome-copilot
Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Focuses on SQL injection prevention, access control, code standards, and anti-pattern detection. Complements SQL optimization prompt for complete development coverage.

Skill 内容语言： 英语

sql-optimization
38.8k
githubgithub/awesome-copilot
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 内容语言： 英语

ssma-console
38.8k
githubgithub/awesome-copilot
Use when: SSMA console operations — create project, generate assessment report, convert schema, migrate data, Oracle to SQL Server migration, schema conversion, data migration

Skill 内容语言： 英语

performing-second-order-sql-injection
32.4k
mukul975mukul975/Anthropic-Cybersecurity-Skills
Detect and exploit second-order SQL injection vulnerabilities where malicious input is stored in a database and later executed in an unsafe SQL query during a different application operation.

Skill 内容语言： 英语

bigquery-basics
30.6k
davila7davila7/claude-code-templates
Manages datasets, tables, and jobs in BigQuery, and integrates with BigQuery ML and Gemini for advanced data analytics and AI-driven insights. Use for SQL queries, resource management, data ingestion, or AI applications on BigQuery.

Skill 内容语言： 英语

cloud-sql-basics
30.6k
davila7davila7/claude-code-templates
Creates and manages Cloud SQL instances for MySQL, PostgreSQL, and SQL Server. Handles backups, high availability, and secure connectivity for relational database workloads on Google Cloud.

Skill 内容语言： 英语

neon-instagres
30.6k
davila7davila7/claude-code-templates
Instantly provision production-ready Postgres databases with Neon Instagres. Use when setting up databases, when users mention PostgreSQL/Postgres, database setup, or need a development database. Works with Drizzle, Prisma, raw SQL.

Skill 内容语言： 英语

postgres-schema-design
30.6k
davila7davila7/claude-code-templates
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features

Skill 内容语言： 英语

postgresql-optimization
30.6k
davila7davila7/claude-code-templates
PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

Skill 内容语言： 英语

postgresql
30.6k
davila7davila7/claude-code-templates
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Skill 内容语言： 英语

supabase-postgres-best-practices
30.6k
davila7davila7/claude-code-templates
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Skill 内容语言： 英语

database-design
30.6k
davila7davila7/claude-code-templates
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Skill 内容语言： 英语

database-schema-designer
30.6k
davila7davila7/claude-code-templates
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.

Skill 内容语言： 英语

neon-postgres
30.6k
davila7davila7/claude-code-templates
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.

Skill 内容语言： 英语

supabase-postgres-best-practices
30.6k
davila7davila7/claude-code-templates
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Skill 内容语言： 英语

add-column-type
29.6k
simstudioaisimstudioai/sim
Add a new table column type to Sim — registry entry, icon, storage shape, coercion, and the behavioral hooks the grid and API read. Use when adding a value kind under `apps/sim/lib/table/column-types/`.

Skill 内容语言： 英语

query-writing
29.1k
langchain-ailangchain-ai/deepagents
Writes and executes SQL queries from simple SELECTs to complex multi-table JOINs, aggregations, and subqueries. Use when the user asks to query a database, write SQL, run a SELECT statement, retrieve data, filter records, or generate reports from database tables.

Skill 内容语言： 英语

schema-exploration
29.1k
langchain-ailangchain-ai/deepagents
Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.

Skill 内容语言： 英语

sql-queries
26.1k
phurynphuryn/pm-skills
Generate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or translating business questions into queries.

Skill 内容语言： 英语

database-designer
25.7k
alirezarezvanialirezarezvani/claude-skills
Use when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.

Skill 内容语言： 英语