Database

Database management and queries

Uses and selection guide

Use these skills when designing service interfaces, changing data models or integrating identity and cache layers. Check the supported database or provider, migration behavior and required credentials before choosing a workflow.

Showing 1-24 of 4331 skills
ahmed-lakosha

odoo-service

by ahmed-lakosha

"Complete Odoo server lifecycle manager — run, deploy, initialize, and manage Odoo across local venv, Docker, and any IDE. Handles server startup/shutdown, environment initialization, database management, Docker orchestration, and IDE configuration for Odoo 14-19."

Database 76 8mo ago
williamzujkowski

database-advanced-optimization

by williamzujkowski

'Use SQL (PostgreSQL) when:'

Database 19 9mo ago
dadbodgeoff

database-migrations

by dadbodgeoff

Safe database migration strategies for zero-downtime deployments. Covers backward-compatible changes, data migrations, and rollback procedures.

Database 791 8mo ago
organvm-iv-taxis

postgres-advanced-patterns

by organvm-iv-taxis

Advanced PostgreSQL patterns for performance optimization, complex queries, indexing strategies, and database design

Database 17 8mo ago
manutej

Psycopg Skill - Customer Support Tech Enablement

by manutej

PostgreSQL adapter for Python - customer support tech enablement for database operations, query optimization, and data management

Database 62 12mo ago
manutej

PostgreSQL Database Administration

by manutej

Comprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniques

Database 62 12mo ago
itzikiusa

db-redis

by itzikiusa

Specialized assistant for exploring and querying a Redis keyspace read-only in Otto's DB Explorer — type-aware reads, SCAN instead of KEYS, key-pattern/namespacing conventions, big-key care, and producing a final command.

Database 0 18d ago
itzikiusa

db-mysql

by itzikiusa

Specialized assistant for exploring and querying a MySQL/MariaDB database read-only in Otto's DB Explorer — dialect idioms, safe schema discovery, EXPLAIN-driven performance, and producing a single final query.

Database 0 18d ago
itzikiusa

db-mongodb

by itzikiusa

Specialized assistant for exploring and querying a MongoDB database read-only in Otto's DB Explorer — find vs aggregation pipelines, $lookup joins, explain plans, schema-less discovery, and producing a single final query.

Database 0 18d ago
itzikiusa

db-clickhouse

by itzikiusa

Specialized assistant for exploring and querying a ClickHouse database read-only in Otto's DB Explorer — columnar/OLAP idioms, FINAL and merge semantics, system.* introspection, approximate aggregates, join pitfalls, and producing a single final query.

Database 0 18d ago
vuralserhat86

firestore_patterns

by vuralserhat86

Firebase Firestore NoSQL patterns, real-time sync ve security rules rehberi.

Database 42 9mo ago
dmonteroh

database-migration-orm

by dmonteroh

"Plan and execute ORM-managed database migrations (Prisma/TypeORM/Sequelize/EF) with zero-downtime patterns, safe backfills, and rollback discipline. Use only for ORM migration tooling (not raw SQL-file migration workflows)."

Database 1 8mo ago
dmonteroh

database-cost-optimization

by dmonteroh

"Reduce database infrastructure spend when costs need optimization by analyzing cost drivers, right-sizing compute/storage/replicas, and proposing verified rollback-ready changes without compromising reliability."

Database 1 8mo ago
ncdevshiv

sqlmap-database-pentesting

by ncdevshiv

'This skill should be used when the user asks to "automate SQL injection testing," "enumerate database structure," "extract database credentials using sqlmap," "dump tables and columns...'

Database 1 1mo ago
dmonteroh

database-performance

by dmonteroh

"Diagnose and fix database performance issues (slow queries, locks, pool saturation, caching, partitioning) using evidence from metrics and query plans."

Database 1 8mo ago
dmonteroh

postgresql-engineering

by dmonteroh

"PostgreSQL-specific schema and data-layer engineering: DDL, data types, constraints, indexing, JSONB, partitioning, RLS, and safe schema evolution. Use when targeting Postgres specifically."

Database 1 8mo ago
dmonteroh

database-migration-sql

by dmonteroh

"Plan and write forward-only SQL migration files with zero-downtime patterns, validation, rollback guidance, and production safety checks for PostgreSQL, MySQL, and SQL Server."

Database 1 8mo ago
dmonteroh

database-architect

by dmonteroh

"Design data layers and database architectures by selecting storage models, modeling schemas, and planning safe evolution with tradeoffs and migration/rollback plans. Use when making data-layer decisions or re-architecting storage."

Database 1 8mo ago
pluginagentmarketplace

postgresql-replication

by pluginagentmarketplace

PostgreSQL streaming replication - setup, monitoring, failover

Database 1 9mo ago
pluginagentmarketplace

postgresql-performance

by pluginagentmarketplace

Optimize PostgreSQL performance - EXPLAIN ANALYZE, indexing, query tuning

Database 1 9mo ago
pluginagentmarketplace

postgresql-monitoring

by pluginagentmarketplace

PostgreSQL monitoring - metrics, alerting, observability

Database 1 9mo ago
pluginagentmarketplace

postgresql-docker

by pluginagentmarketplace

PostgreSQL in containers - Docker, Kubernetes, production configs

Database 1 9mo ago
pluginagentmarketplace

postgresql-admin

by pluginagentmarketplace

Administer PostgreSQL - security, roles, permissions, maintenance

Database 1 9mo ago
pluginagentmarketplace

postgresql-backup

by pluginagentmarketplace

PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR

Database 1 9mo ago