Skip to main content
skillsmp

Menu

Bases SQL

Parcourez les skills pour MySQL, PostgreSQL et la gestion de bases SQL

Les catégories, les étoiles GitHub et la date de dernière mise à jour à la source servent à structurer et ordonner le catalogue. Ces signaux ne constituent ni une recommandation, ni une certification de qualité, ni un contrôle de sécurité, ni une garantie d’adéquation. Consultez la page du skill et sa source avant utilisation.

13 875 résultats

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.

Langue du contenu du Skill : espagnol

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

Langue du contenu du Skill : japonais

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

Langue du contenu du Skill : coréen

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.

Langue du contenu du Skill : turc

postgres-patterns
253.2k
affaan-maffaan-m/ECC
用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

Langue du contenu du Skill : chinois

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

Langue du contenu du Skill : chinois

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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".

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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).

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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/`.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais

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.

Langue du contenu du Skill : anglais