Skip to main content
skillsmp

Menü

SQL-Datenbanken

Agent Skills für MySQL, PostgreSQL und SQL-Datenbankmanagement durchsuchen

Kategorien, GitHub-Sterne und der Zeitpunkt der letzten Quellaktualisierung ordnen den Katalog. Diese Signale sind weder eine Empfehlung noch eine Qualitätszertifizierung, Sicherheitsprüfung oder Eignungsgarantie. Prüfen Sie vor der Nutzung die Detailseite und die Quelle.

13.875 Ergebnisse

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.

Sprache des Skill-Inhalts: Spanisch

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

Sprache des Skill-Inhalts: Japanisch

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

Sprache des Skill-Inhalts: Koreanisch

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.

Sprache des Skill-Inhalts: Türkisch

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

Sprache des Skill-Inhalts: Chinesisch

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

Sprache des Skill-Inhalts: Chinesisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch

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.

Sprache des Skill-Inhalts: Englisch