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
43

database-optimization

Practical rules for query tuning, schema choices, and safe database performance work.

ABIvan-Tech
ABIvan-Tech
databases
open
sql-databases
42

prisma-orm

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

vuralserhat86
vuralserhat86
databases
open
sql-databases
42

postgres-pro

PostgreSQL specialist for database administration, performance optimization, and high availability. Invoke for query tuning, replication, JSONB, extensions, maintenance. Keywords: PostgreSQL, EXPLAIN, replication, JSONB, pg_stat.

vuralserhat86
vuralserhat86
databases
open
sql-databases
42

prisma-specialist

Prisma ORM, schema design, migrations ve type-safe database access.

vuralserhat86
vuralserhat86
databases
open
sql-databases
42

backend-database

Repository pattern, transactions, caching ve query optimization.

vuralserhat86
vuralserhat86
databases
open
sql-databases
42

database-design

Schema tasarımı, migration stratejileri, indexing, query optimization ve database best practices.

vuralserhat86
vuralserhat86
databases
open
sql-databases
42

write-query

Write optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.

clawpod-app
clawpod-app
databases
open
sql-databases
41

sqlite-db

General guide for using the sqlite3 CLI to build composable knowledge databases. Use this skill when creating SQLite databases, designing schemas, querying data, managing relationships, or building new sqlite-based domain skills. Provides the foundational patterns that all specialized sqlite skills build upon.

bfollington
bfollington
databases
open
sql-databases
41

scythe

Generate type-safe database access code from annotated SQL queries in 10 languages across 10 databases. Use when writing SQL with scythe annotations, configuring scythe.toml, choosing backends, linting/formatting SQL, or integrating scythe into a project.

Goldziher
Goldziher
databases
open
sql-databases
41

deck-management

How decks are stored in SQL, how to create/read/update/delete decks. Read before working with deck data.

BuilderIO
BuilderIO
databases
open
sql-databases
40

sql

Guide for working with SQL queries, in particular for SQLite. Use this skill when writing SQL queries, analyzing database schemas, designing migrations, or working with SQLite-related code.

maragudk
maragudk
databases
open
sql-databases
40

ultrathink-memory

Persistent memory system for UltraThink — search, save, and recall project context, decisions, and patterns across sessions using Postgres-backed fuzzy search with synonym expansion.

InugamiDev
InugamiDev
databases
open
sql-databases
40

sqlite

SQLite patterns with better-sqlite3, libSQL, Turso local dev, WAL mode, migrations, embedded database use cases, and Drizzle ORM integration

InugamiDev
InugamiDev
databases
open
sql-databases
40

prisma

Prisma ORM patterns, schema design, migrations, relations, transactions, raw queries, and production optimization

InugamiDev
InugamiDev
databases
open
sql-databases
40

postgresql

PostgreSQL optimization, indexing strategies, CTEs, window functions, extensions (pg_trgm, PostGIS), partitioning, and production tuning

InugamiDev
InugamiDev
databases
open
sql-databases
40

search

Full-text search implementation with Algolia, MeiliSearch, PostgreSQL pg_trgm, search UX patterns, autocomplete, and relevance tuning

InugamiDev
InugamiDev
databases
open
sql-databases
40

mongodb

MongoDB schema design, aggregation pipelines, indexing strategies, change streams, transactions, and production optimization

InugamiDev
InugamiDev
databases
open
sql-databases
40

using-neon

Guides and best practices for working with Neon Serverless Postgres. Covers getting started, local development with Neon, choosing a connection method, Neon features, authentication (@neondatabase/...

benjaminasterA
benjaminasterA
databases
open
sql-databases
40

postgresql

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

benjaminasterA
benjaminasterA
databases
open
sql-databases
40

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.

benjaminasterA
benjaminasterA
databases
open
sql-databases
40

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

benjaminasterA
benjaminasterA
databases
open
sql-databases
40

database-optimization

Database query optimization — EXPLAIN ANALYZE, query plans, index hints, materialized views, partitioning

InugamiDev
InugamiDev
databases
open
sql-databases
40

database-transactions

Transaction isolation levels, distributed transactions, saga pattern, optimistic/pessimistic locking, and ACID guarantees across SQL and NoSQL databases

InugamiDev
InugamiDev
databases
open
sql-databases
40

database-indexing

Database indexing strategies — B-tree, GIN, GiST, hash, BRIN index types, EXPLAIN ANALYZE interpretation, query plan optimization, partial and composite indexes, index maintenance for PostgreSQL

InugamiDev
InugamiDev
databases
open
Previous
Page 31 / 81
Next