搵技能.../

SQL 數據庫 | Skills Pool

分類SQL 數據庫

SQL 數據庫

搜尋睇全部分類

問 AI

SQL 數據庫

分類

SQL 數據庫除錯銷售同市場推廣 LLM 同 AI 系統管理生產力同整合代碼質素 Git 工作流程架構模式文件項目管理測試金融同投資安全知識庫技術文檔 Backend Frontend 教育 CI/CD 自動化工具機器學習內容創作數據工程遊戲開發學術腳本編寫 CMS 同平台流動裝置雲端 IDE 插件套件同發佈數據分析框架內部結構媒體設計 Full Stack 地產同法律生物信息學 CLI 工具計算化學容器實驗室工具數據庫工具健康同健身智能合約監控域名同 DNS 工具 Web3 工具養生同健康支付文學同寫作電商開發哲學同倫理天文同物理電子商務占卜同玄學手工藝術科學計算商業應用 DeFi NoSQL 數據庫烹飪 $Undefined

睇全部分類

SQL 數據庫除錯銷售同市場推廣 LLM 同 AI 系統管理生產力同整合代碼質素 Git 工作流程架構模式文件項目管理測試金融同投資安全知識庫技術文檔 Backend Frontend 教育 CI/CD 自動化工具機器學習內容創作數據工程遊戲開發學術腳本編寫 CMS 同平台流動裝置雲端 IDE 插件套件同發佈數據分析框架內部結構媒體設計 Full Stack 地產同法律生物信息學 CLI 工具計算化學容器實驗室工具數據庫工具健康同健身智能合約監控域名同 DNS 工具 Web3 工具養生同健康支付文學同寫作電商開發哲學同倫理天文同物理電子商務占卜同玄學手工藝術科學計算商業應用 DeFi NoSQL 數據庫烹飪 $Undefined

SQL 數據庫

Py Sqlmodel Patterns

SQLModel and async SQLAlchemy patterns. Use when working with database models, queries, relationships, or debugging ORM issues.

Previous 1…160 161 162…168 Next

Bigquery

Write efficient BigQuery SQL with partition pruning, clustering, cost estimation, and slot management. Use when writing or optimizing BigQuery queries, designing partitioned/clustered tables, estimating query cost with dry-run, or debugging slot contention. Do not use for PostgreSQL/MySQL queries (prefer orm-patterns) or real-time OLTP workloads.

merceralex397-collab0

Neondb Setup

Set up NeonDB PostgreSQL database with Drizzle ORM for a project. Use when the user wants to configure NeonDB or add serverless Postgres.

Database

This skill should be used when the user asks to "create a migration", "modify a database schema", "add a table", "update Drizzle/Prisma/EF Core schema", or works on PostgreSQL data models.

Postgresql Db

PostgreSQL database schema design with strict naming conventions. Use when creating database schemas, tables, columns, or writing SQL for PostgreSQL. Enforces: (1) Snake_case for all table and column names, (2) Project prefix for all tables, (3) No reserved keywords, (4) PostgreSQL best practices. Includes schema validation and automated name correction.

Memory Notion Sync

Bidirectional sync between local memory store and [FOS] Memory Notion database. Reference this skill whenever pushing memories to Notion or pulling user changes back to the local SQLite store. Syncs .memory/memory.db only — for intelligence pattern sync see intelligence-notion-sync.

Database Schema Design

Design relational database schemas with tables, migrations, and best practices. Use for scalable backend systems.

NabeelManjhoti0

When to use this skill:

Write secure, performant database queries using parameterized queries, proper eager loading, and transaction management. Use this skill when writing database queries, ORM operations, raw SQL statements, or repository methods. When working on files in repositories/, queries/, services/, or any code that interacts with the database. When optimizing query performance, preventing N+1 queries, implementing transactions, adding query timeouts, or caching expensive queries. When reviewing code for SQL injection vulnerabilities.

mshafei721-turbocat-claude-skills-backend-models-skill-md

Define database models and schemas with proper naming, data types, constraints, relationships, and indexing strategies. Use this skill when creating or modifying database models, entity definitions, or schema files. When working on files like models.py, models/*.ts, entities/*.ts, schema.prisma, or ORM model definitions. When defining table structures, setting up foreign key relationships, adding database constraints (NOT NULL, UNIQUE), choosing appropriate data types, or implementing model-level validation.

Mongodb

Write MongoDB queries, aggregation pipelines, and schema designs

Sql Optimization

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.

Convex Schema Validator

Defining and validating database schemas with proper typing, index configuration, optional fields, unions, and migration strategies for schema changes

Sql

在创建新 MySQL 表时，确保重复字段（如创建人、时间、系统 ID 等）的类型、长度及注释与系统现有标准表一致。

Supabase Postgres Best Practices

Audit SQL queries and schema design against Supabase Postgres Best Practices. Use when asked to "optimize my database", "check my SQL", "review RLS policies", or "improve postgres performance".

Database Design

Database design principles for Oracle. Schema design, indexing strategy, query optimization.

Delete Batch

Bulk delete transactions by filter from the OptimalOS transactions table

Performing Second Order Sql Injection

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.

Prisma

Prisma ORM patterns including Prisma Client usage, queries, mutations, relations, transactions, and schema management. Use when working with Prisma database operations or schema definitions.

mfcollins3-standup-github-skills-azure-database-postgresql-skill-md

Expert knowledge for Azure Database for PostgreSQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when using pgvector, Azure AI/OpenAI, Entra auth/Private Link, sharding/replication, or CI/CD/Bicep deployments, and other Azure Database for PostgreSQL related development tasks. Not for Azure Database for MySQL (use azure-database-mysql), Azure Database for MariaDB (use azure-database-mariadb), Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance).

mfcollins3-standup-github-skills-azure-database-mysql-skill-md

Expert knowledge for Azure Database for MySQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when deploying MySQL Flexible Server, tuning performance, configuring HA/networking, securing access, or integrating apps, and other Azure Database for MySQL related development tasks. Not for Azure Database for MariaDB (use azure-database-mariadb), Azure Database for PostgreSQL (use azure-database-postgresql), Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance).

Use Uppercase Sql Keywords

Enforces uppercase SQL keywords (SELECT, FROM, WHERE, etc.) to visually distinguish them from table and column names. Use when writing or reviewing raw SQL queries. Do not use for ORM-generated queries or query builder APIs where keyword casing is controlled by the library.

Orm Patterns

Write correct SQLAlchemy 2.0 queries, avoid N+1 problems, and use eager loading strategies. Use when writing SQLAlchemy models or queries, fixing N+1 query bugs, choosing between joinedload/selectinload/subqueryload, or migrating from SQLAlchemy 1.x to 2.0 style. Do not use for BigQuery analytics (prefer bigquery) or raw SQL without an ORM.

merceralex397-collab0

Database

Database guide for PostgreSQL schema (DBML-based design), JPA entity mapping, and Redis configuration for Refresh Token storage.

Database Performance Tuning

Use when performing database performance tuning — provides a systematic approach to diagnosing and resolving database performance issues. Covers query analysis, index optimization, schema review, configuration tuning, connection management, and capacity planning for relational and NoSQL databases.

cloudthinker-ai0

Sql Query

T-SQL 查詢撰寫規範：參數化查詢、索引友善寫法、效能陷阱迴避與可讀性格式要求。適用於 SQL Server 與 Oracle 雙資料庫。

Query Postgres

Connect to a PostgreSQL database to inspect its schema (tables, columns, indexes, foreign keys, views) and execute read-only SQL queries. Use when the user needs to explore or retrieve data from a PostgreSQL database.

Query Sqlserver

Connect to a Microsoft SQL Server database to inspect its schema (tables, columns, indexes, foreign keys, views) and execute read-only SQL queries. Use when the user needs to explore or retrieve data from a SQL Server database.

Db Agent

Design database schemas, write migrations, optimize queries, and document data models. Analyzes existing schema patterns and follows them strictly. Works across PostgreSQL, MySQL, SQLite, MongoDB, and other databases.

Query Mongodb

Connect to a MongoDB database to inspect its schema (databases, collections, indexes, document structure) and execute read-only queries (find, aggregate). Use when the user needs to explore or retrieve data from a MongoDB database.

Postgresql

Guides PostgreSQL schema design, index selection (B-tree/GIN/GiST), query optimization with EXPLAIN ANALYZE, connection pooling via pgbouncer, migration workflows (alembic/flyway/dbmate), transaction isolation levels, VACUUM tuning, table partitioning, and pg_stat_statements analysis. Use when writing schemas, optimizing queries, configuring connections, or planning migrations against PostgreSQL.

merceralex397-collab0