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
946

sqlite-map-parser

Parse SQLite databases into structured JSON data. Use when exploring unknown database schemas, understanding table relationships, and extracting map data as JSON.

benchflow-ai
benchflow-ai
databases
open
sql-databases
934

relational-database-mcp-cloudbase

This is the required documentation for agents operating on the CloudBase Relational Database. It lists the only four supported tools for running SQL and managing security rules. Read the full content to understand why you must NOT use standard Application SDKs and how to safely execute INSERT, UPDATE, or DELETE operations without corrupting production data.

TencentCloudBase
TencentCloudBase
databases
open
sql-databases
913

moai-domain-database

Database specialist covering PostgreSQL, MongoDB, Redis, Oracle, and advanced data patterns for modern applications. Use for database schema design, query optimization, indexing strategies, or data modeling.

modu-ai
modu-ai
databases
open
sql-databases
878

pg-dump

Consult PostgreSQL's pg_dump implementation for guidance on system catalog queries and schema extraction when implementing pgschema features. Use this skill when adding new schema object support, debugging inspector.go queries, understanding how PostgreSQL represents objects internally, or handling version-specific features across PostgreSQL 14-18.

pgplex
pgplex
databases
open
sql-databases
878

postgres-syntax

Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features. Use this skill when generating DDL in internal/diff/*.go, validating SQL syntax, understanding keyword precedence, or learning how PostgreSQL handles specific constructs like triggers, indexes, generated columns, or constraint triggers.

pgplex
pgplex
databases
open
sql-databases
878

validate-db

Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively. Use this skill whenever you need to test queries against a real database, verify how PostgreSQL stores or formats objects, debug introspection issues, or check version-specific behavior (PostgreSQL 14-18).

pgplex
pgplex
databases
open
sql-databases
807

axiom-database-migration

Use when adding/modifying database columns, encountering "FOREIGN KEY constraint failed", "no such column", "cannot add NOT NULL column" errors, or creating schema migrations for SQLite/GRDB/SQLiteData - prevents data loss with safe migration patterns and testing workflows for iOS/macOS apps

CharlesWiltgen
CharlesWiltgen
databases
open
sql-databases
807

axiom-grdb

Use when writing raw SQL queries with GRDB, complex joins, ValueObservation for reactive queries, DatabaseMigrator patterns, query profiling under performance pressure, or dropping down from SQLiteData for performance - direct SQLite access for iOS/macOS

CharlesWiltgen
CharlesWiltgen
databases
open
sql-databases
807

axiom-sqlitedata-ref

SQLiteData advanced patterns, @Selection column groups, single-table inheritance, recursive CTEs, database views, custom aggregates, TableAlias self-joins, JSON/string aggregation

CharlesWiltgen
CharlesWiltgen
databases
open
sql-databases
807

axiom-sqlitedata

Use when working with SQLiteData @Table models, CRUD operations, query patterns, CloudKit SyncEngine setup, or batch imports. Covers model definitions, @FetchAll/@FetchOne, upsert patterns, database setup with Dependencies.

CharlesWiltgen
CharlesWiltgen
databases
open
sql-databases
807

axiom-audit-database-schema

Use when the user mentions database schema review, migration safety, GRDB migration audit, or SQLite schema checking.

CharlesWiltgen
CharlesWiltgen
databases
open
sql-databases
807

axiom-sqlitedata-ref

SQLiteData advanced patterns, @Selection column groups, single-table inheritance, recursive CTEs, database views, custom aggregates, TableAlias self-joins, JSON/string aggregation

CharlesWiltgen
CharlesWiltgen
databases
open
sql-databases
761

database-performance

Database access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins. Works with EF Core and Dapper.

Aaronontheweb
Aaronontheweb
databases
open
sql-databases
759

supabase-postgres-best-practices

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

openai
openai
databases
open
sql-databases
711

neon-postgres

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.

sickn33
sickn33
databases
open
sql-databases
711

sql-injection-testing

This skill should be used when the user asks to "test for SQL injection vulnerabilities", "perform SQLi attacks", "bypass authentication using SQL injection", "extract database information through injection", "detect SQL injection flaws", or "exploit database query vulnerabilities". It provides comprehensive techniques for identifying, exploiting, and understanding SQL injection attack vectors across different database systems.

sickn33
sickn33
databases
open
sql-databases
707

neon-instagres

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.

Dicklesworthstone
Dicklesworthstone
databases
open
sql-databases
681

nop-orm-modeler

Generate, validate, and modify Nop ORM models from MySQL DDL/SQL or business requirements. Covers entity modeling, relationships, domains, dictionaries, displayName localization, and ORM file organization (Delta mode). Use for database-first or requirements-first ORM development.

entropy-cloud
entropy-cloud
databases
open
sql-databases
673

nop-orm-modeler

专门用于设计、创建、验证和修改Nop平台的ORM模型文件(.orm.xml)

entropy-cloud
entropy-cloud
databases
open
sql-databases
657

sql

Generate safe, correct SQL scripts for the Rock RMS database. Handles INSERT, UPDATE, DELETE, SELECT queries, data migrations, and seed scripts that respect Rock's schema conventions (PersonAlias, audit columns, FK constraints, DefinedType/DefinedValue lookups, Guid-based references). Use when the user says "create a sql script", "write sql", "insert data", "seed data", "data migration", "update records", "sql for Rock", "populate data", "add test data", "query Rock database", or any request involving direct SQL against the Rock RMS database. Also use when the user describes data they want to add, modify, or query in Rock — even if they don't explicitly say "SQL" — such as "add 100 attendance records", "create a new campus", "give Ted Decker some financial transactions", or "set up check-in data". If the task involves Rock database records and SQL is the right tool, use this skill.

SparkDevNetwork
SparkDevNetwork
databases
open
sql-databases
654

plain-postgres-doctor

Check overall database health — schema correctness and operational health. Use when asked to check the database, validate schema, optimize indexes, or diagnose Postgres problems.

dropseed
dropseed
databases
open
sql-databases
637

wren-sql

Write and correct SQL queries targeting Wren Engine — covers MDL query rules, filter strategies, data types (ARRAY, STRUCT, JSON/VARIANT), date/time functions, Calculated Fields, BigQuery dialect quirks, and error diagnosis. Use when generating or debugging SQL for any Wren Engine data source.

Canner
Canner
databases
open
sql-databases
634

sql-optimization-patterns

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.

rmyndharis
rmyndharis
databases
open
sql-databases
634

sql-pro

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems. Use PROACTIVELY for database optimization or complex analysis.

rmyndharis
rmyndharis
databases
open
Previous
Page 9 / 81
Next