قواعد بيانات SQL

تصفح مهارات الوكيل لـ MySQL و PostgreSQL وإدارة قواعد بيانات SQL

تساعد الفئات ونجوم GitHub وتاريخ آخر تحديث في المصدر على تنظيم الفهرس وترتيب نتائجه. ولا تمثل هذه الإشارات توصية من SkillsMP أو اعتمادًا للجودة أو مراجعةً للسلامة أو ضمانًا للملاءمة. افتح صفحة المهارة وافحص مصدرها قبل الاستخدام.

١٣٬٨٧٥ نتيجة

postgres-patterns

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.

لغة محتوى المهارة: الإسبانية

postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

لغة محتوى المهارة: اليابانية

postgres-patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

لغة محتوى المهارة: الكورية

postgres-patterns

Sorgu optimizasyonu, şema tasarımı, indeksleme ve güvenlik için PostgreSQL veritabanı kalıpları. Supabase en iyi uygulamalarına dayanır.

لغة محتوى المهارة: التركية

postgres-patterns

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

لغة محتوى المهارة: الصينية

postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

لغة محتوى المهارة: الصينية

database-migrations

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.

لغة محتوى المهارة: الإنجليزية

postgres-patterns

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.

لغة محتوى المهارة: الإنجليزية

database-migrations

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.

لغة محتوى المهارة: الإنجليزية

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.

لغة محتوى المهارة: الإنجليزية

postgres-patterns

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.

لغة محتوى المهارة: الإنجليزية

safe-sql-execution

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

لغة محتوى المهارة: الإنجليزية

lobehub/lobehub

Use for Drizzle schemas and queries: tables, indexes, relations, joins and inferred types. Rollout belongs to db-migrations.

لغة محتوى المهارة: الإنجليزية

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

لغة محتوى المهارة: الإنجليزية

create-database-migration

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.

لغة محتوى المهارة: الإنجليزية

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

لغة محتوى المهارة: الإنجليزية

Conventions and review steps for writing analytics SQL against the warehouse. Use whenever the task involves querying tables, building a report, or aggregating metrics.

لغة محتوى المهارة: الإنجليزية

querying-local-postgres

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

لغة محتوى المهارة: الإنجليزية

writing-clickhouse-queries

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

لغة محتوى المهارة: الإنجليزية

setting-up-a-data-warehouse-source

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

لغة محتوى المهارة: الإنجليزية

tuning-incremental-sync-config

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

لغة محتوى المهارة: الإنجليزية

postgresql-table-design

wshobson/agents

Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

لغة محتوى المهارة: الإنجليزية

sql-optimization-patterns

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

لغة محتوى المهارة: الإنجليزية

creating-oracle-to-postgres-migration-bug-report

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

لغة محتوى المهارة: الإنجليزية

migrating-oracle-to-postgres-stored-procedures

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

لغة محتوى المهارة: الإنجليزية

postgresql-code-review

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

لغة محتوى المهارة: الإنجليزية

postgresql-optimization

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

لغة محتوى المهارة: الإنجليزية

reviewing-oracle-to-postgres-migration

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

لغة محتوى المهارة: الإنجليزية

sql-code-review

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

لغة محتوى المهارة: الإنجليزية

sql-optimization

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

لغة محتوى المهارة: الإنجليزية

github/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

لغة محتوى المهارة: الإنجليزية

performing-second-order-sql-injection

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

لغة محتوى المهارة: الإنجليزية

bigquery-basics

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

لغة محتوى المهارة: الإنجليزية

cloud-sql-basics

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

لغة محتوى المهارة: الإنجليزية

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

لغة محتوى المهارة: الإنجليزية

postgres-schema-design

davila7/claude-code-templates

Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features

لغة محتوى المهارة: الإنجليزية

postgresql-optimization

davila7/claude-code-templates

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

لغة محتوى المهارة: الإنجليزية

davila7/claude-code-templates

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

لغة محتوى المهارة: الإنجليزية

supabase-postgres-best-practices

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

لغة محتوى المهارة: الإنجليزية

database-design

davila7/claude-code-templates

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

لغة محتوى المهارة: الإنجليزية

database-schema-designer

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

لغة محتوى المهارة: الإنجليزية

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

لغة محتوى المهارة: الإنجليزية

supabase-postgres-best-practices

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

لغة محتوى المهارة: الإنجليزية

add-column-type

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

لغة محتوى المهارة: الإنجليزية

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

لغة محتوى المهارة: الإنجليزية

schema-exploration

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

لغة محتوى المهارة: الإنجليزية

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

لغة محتوى المهارة: الإنجليزية

database-designer

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

لغة محتوى المهارة: الإنجليزية