skills.homescapability registry 搜尋

home/categories/sql-databases

category focus

SQL

PostgreSQL, MySQL, and relational DBs.

1935 個技能all categories

sorting

stars

current ordering strategy

query

all entries

refine the visible subset

sql-databases

185

bel-crm-schema-write-db

This skill should be used when working with the CRM PostgreSQL database for sales, contacts, companies, and opportunities. Use this skill when the user asks to insert, update, query, or analyze data in the CRM database (may be called crm or db), or when SQL queries need to be created for company_site, person, sales_opportunity, or event tables. This skill provides comprehensive schema knowledge and PostgreSQL-specific SQL examples tailored to the CRM data model.

majiayu000

databases

sql-databases

185

bel-crm-sql-rules

CRITICAL: PostgreSQL MCP Server SQL limitations and correct patterns. This skill MUST be consulted before writing any SQL for the CRM database. Documents what works and what DOES NOT work with mcp__postgresql__ tools.

majiayu000

databases

sql-databases

185

database-prisma

Prisma ORM and PostgreSQL database management for EFT-Tracker. Handles schema design, migrations, client generation, and Neon database branches. Activates when user mentions: database, schema, migration, Prisma, model, relation, PostgreSQL, Neon, db push, db pull.

majiayu000

databases

sql-databases

185

database-management-patterns

Comprehensive guide for database management patterns covering PostgreSQL and MongoDB including schema design, indexing, transactions, replication, and performance tuning

majiayu000

databases

sql-databases

185

database-design-expert

Expert in database schema design with focus on normalization, indexing strategies, FTS optimization, and performance-oriented architecture for desktop applications

majiayu000

databases

sql-databases

185

databases-sql

SQL database querying, optimization, and data management for analytics

majiayu000

databases

sql-databases

185

database-standard

Database design standards defining primary keys, foreign keys, audit fields, soft delete, junction tables. PostgreSQL style preferred, SQL lowercase without comments.

majiayu000

databases

sql-databases

185

database-optimization-guru

Database expert for query optimization, indexing, schema design, and performance tuning

majiayu000

databases

sql-databases

185

database-explorer

Allows read-only access to the SQL database to allow querying and analysis using natural language

majiayu000

databases

sql-databases

185

database-analyzer

Analyze and optimize database schemas, identify performance issues, and suggest improvements. Use when working with database structure, indexes, or query performance.

majiayu000

databases

sql-databases

185

database-schema-analyzer

Analyze PostgreSQL/Supabase database schemas for design quality, security, performance, and best practices. Use when reviewing schemas, migrations, RLS policies, or when user mentions database design, indexing, or security issues.

majiayu000

databases

sql-databases

185

database-implementation

Database schema design, migrations, query optimization with SQL, Exposed ORM, Flyway. Use for database, migration, schema, sql, flyway tags. Provides migration patterns, validation commands, rollback strategies.

majiayu000

databases

sql-databases

185

database-schema-expert

Expert knowledge on Supabase Postgres schema, Drizzle ORM patterns, normalized user tables, relations, query patterns, and migrations. Use this skill when user asks about "database", "schema", "drizzle", "query", "table", "postgres", "supabase", "migration", or database design questions.

majiayu000

databases

sql-databases

185

databases-architecture-skill

Master database design (SQL, NoSQL), system architecture, API design (REST, GraphQL), and building scalable systems. Learn PostgreSQL, MongoDB, system design patterns, and enterprise architectures.

majiayu000

databases

sql-databases

185

database-indexing-strategy

Design and implement database indexing strategies. Use when creating indexes, choosing index types, or optimizing index performance in PostgreSQL and MySQL.

majiayu000

databases

sql-databases

181

whodb

Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases.

xiaoyuge886

databases

sql-databases

181

agent-sql-pro

Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. Masters advanced SQL features, indexing strategies, and data warehousing patterns.

xiaoyuge886

databases

sql-databases

176

ef-core-migrations

Handle EF Core schema changes in Egroo. Use for: adding or changing entity properties, owned types, relationships, indexes, table mappings, naming conventions, or anything in DataContext/OnModelCreating that changes the PostgreSQL schema. Covers when to add a migration, how to update the database, and what to verify afterwards.

jihadkhawaja

databases

sql-databases

171

data-write-query

Escreve SQL otimizado para o stack Evolution (PostgreSQL primário) com boas práticas. Use quando precisar traduzir uma necessidade de dados em SQL, construir uma query com múltiplas CTEs, joins e agregações, otimizar uma query contra tabelas grandes, ou obter sintaxe específica para consultas no banco do Evo CRM, Evo AI, ou qualquer serviço do stack Evolution. Dialetos secundários disponíveis: Snowflake, BigQuery, MySQL, DuckDB.

EvolutionAPI

databases

sql-databases

170

adding-fields-to-the-object-persisted-by-a-sql-crud-microservice

Adds fields to an object that is persisted to a SQL database by a CRUD microservice. Use when explicitly asked by the user to add fields (or properties) to the object; or when explicitly asked by the user to add columns to the database table.

microbus-io

databases

sql-databases

170

renaming-the-object-persisted-by-a-sql-crud-microservice

Renames the type of the object used by a SQL CRUD microservice. Use when explicitly asked by the user to rename the object or its type definition.

microbus-io

databases

sql-databases

170

adding-a-new-sql-crud-microservice

Creates and initializes a new microservice that provides CRUD operations to a SQL database such as MySQL, Postgres or Microsoft SQL Server. Use when explicitly asked by the user to create a new SQL or CRUD microservice to persist an object.

microbus-io

databases

sql-databases

169

swiftdata-architecture

Deep dive into SwiftData design patterns and best practices. Covers schema design, query patterns, repository pattern, and performance optimization. Use when designing data models or improving SwiftData usage.

rshankras

databases

sql-databases

168

howto-develop-with-postgres

Use when writing database access code, creating schemas, or managing transactions with PostgreSQL - enforces transaction safety with TX_ naming, read-write separation, type safety for UUIDs/JSONB, and snake_case conventions to prevent data corruption and type errors

ed3dai

databases

Page 19 / 81