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
2

control-sessions

Control active sessions by terminating problematic sessions, managing runaway queries, and handling blocking situations

teradata-labs
teradata-labs
databases
open
sql-databases
2

supabase-rls-policy

Expert guidance for writing Supabase PostgreSQL row-level security (RLS) policies. Use when creating, modifying, or troubleshooting RLS policies for Supabase databases, implementing access control patterns, or setting up table-level security rules.

linehaul-ai
linehaul-ai
databases
open
sql-databases
2

database-orm

Interaction with NeonDB Postgres using Drizzle ORM.

AbdulSamad94
AbdulSamad94
databases
open
sql-databases
2

postgres-migrations

Write safe PostgreSQL migrations that avoid blocking reads/writes. Use when creating migrations, adding columns, indexes, constraints, or modifying tables. Based on Squawk linter rules.

frizzle-chan
frizzle-chan
databases
open
sql-databases
2

database-design

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

whodaniel
whodaniel
databases
open
sql-databases
2

db-designer

Generate database schema from feature descriptions. User doesn't see SQL. Use when: features require data persistence. Triggers: internal use only.

timequity
timequity
databases
open
sql-databases
2

neo4j-schema

Core Neo4j schema reference with all labels, relationships, data types, and indexes. Use when exploring database structure, checking field types, or understanding the financial knowledge graph schema.

faisalanjum
faisalanjum
databases
open
sql-databases
2

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.

bennoloeffler
bennoloeffler
databases
open
sql-databases
2

database-design

Designs comprehensive database schemas including relational and NoSQL models, normalization, indexing strategies, relationship modeling, data types, constraints, and performance optimization. Covers entity-relationship diagrams, schema migrations, partitioning, and best practices for PostgreSQL, MySQL, MongoDB, and other databases. Use when designing databases, creating schemas, modeling data, optimizing queries, or when users mention "database design", "schema design", "data modeling", "ERD", "normalization", "indexing", or "database architecture".

DauQuangThanh
DauQuangThanh
databases
open
sql-databases
2

database-migration

DBマイグレーション支援。スキーマ変更やマイグレーション作成依頼時に使用。ORM自動検出、命名規則確認、既存マイグレーションとの整合性を検証。

ukwhatn
ukwhatn
databases
open
sql-databases
2

postgis

MANDATORY when working with geographic data, spatial queries, geometry operations, or location-based features - enforces PostGIS 3.6.1 best practices including ST_CoverageClean, SFCGAL 3D functions, and bigint topology

troykelly
troykelly
databases
open
sql-databases
2

database-patterns

Database operations: migrations, queries, transactions, and performance. Use when: - Writing database migrations - Optimizing queries or adding indexes - Managing transactions and connections - Setting up connection pooling - Designing audit logging Keywords: database, migration, SQL, query optimization, index, transaction, connection pool, N+1, ORM, audit log

phrazzld
phrazzld
databases
open
sql-databases
2

python-peewee

Patterns for using Peewee ORM with DatabaseProxy and scoped connections/transactions. Use when setting up DatabaseProxy, managing connection_context/atomic blocks, or writing tests with SQLite.

narumiruna
narumiruna
databases
open
sql-databases
2

rails-model-patterns

ActiveRecord model patterns and conventions for Rails. Automatically invoked when working with models, associations, validations, scopes, callbacks, or database schema design. Triggers on "model", "ActiveRecord", "association", "has_many", "belongs_to", "validation", "validates", "scope", "callback", "migration", "schema", "index", "foreign key".

ag0os
ag0os
databases
open
sql-databases
1

data-analysis-sql

SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.

pluginagentmarketplace
pluginagentmarketplace
databases
open
sql-databases
1

data-wrangler

Transform and export data using DuckDB SQL. Read CSV/Parquet/JSON/Excel/databases, apply SQL transformations (joins, aggregations, PIVOT/UNPIVOT, sampling), and optionally write results to files. Use when the user wants to: (1) Clean, filter, or transform data, (2) Join multiple data sources, (3) Convert between formats (CSV→Parquet, etc.), (4) Create partitioned datasets, (5) Sample large datasets, (6) Export query results. Prefer this over in-context reasoning for datasets with thousands of rows or complex transformations.

richard-gyiko
richard-gyiko
databases
open
sql-databases
1

quick-query

Run ad-hoc MongoDB queries in natural language. Translates natural language queries into MongoDB queries and executes them. Use for quick data exploration, answering "how many" questions, finding specific records, or aggregating statistics.

harehimself
harehimself
databases
open
sql-databases
1

sql-analysis

Master SQL for data analysis with complex queries, joins, aggregations, window functions, and query optimization.

spjoshis
spjoshis
databases
open
sql-databases
1

databases-sql

SQL database querying, optimization, and data management for analytics

pluginagentmarketplace
pluginagentmarketplace
databases
open
sql-databases
1

sql-analytics

Master analytical SQL including window functions, CTEs, aggregations, and query optimization for BI workloads

pluginagentmarketplace
pluginagentmarketplace
databases
open
sql-databases
1

duckdb

Fast in-process analytical database for SQL queries on DataFrames, CSV, Parquet, JSON files, and more. Use when user wants to perform SQL analytics on data files or Python DataFrames (pandas, Polars), run complex aggregations, joins, or window functions, or query external data sources without loading into memory. Best for analytical workloads, OLAP queries, and data exploration.

silvainfm
silvainfm
databases
open
sql-databases
1

database-migration

Safe database migration procedures with backward compatibility, backups, and rollback strategies. Use when creating, modifying, or dropping database schemas. Covers migration creation, testing, execution, and rollback.

HelloWorldSungin
HelloWorldSungin
databases
open
sql-databases
1

gcp-bq-table-management

Use when creating BigQuery tables, implementing partitioning or clustering, managing table schemas, or optimizing table structure. Covers time-based partitioning, range partitioning, clustering strategies, DDL commands, and table configuration.

FunnelEnvy
FunnelEnvy
databases
open
Previous
Page 61 / 81
Next