数据库

数据库管理与查询

用途与选择建议

这类技能适用于服务接口设计、数据模型变更,以及身份认证和缓存集成。选择时检查支持的数据库或服务商、迁移行为和凭证要求,优先选用能在测试环境验证的工作流。

显示 1-24 / 共 4331 个技能
ahmed-lakosha

odoo-service

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

数据库 76 8个月前
williamzujkowski

database-advanced-optimization

williamzujkowski

'Use SQL (PostgreSQL) when:'

数据库 19 9个月前
dadbodgeoff

database-migrations

dadbodgeoff

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

数据库 791 8个月前
organvm-iv-taxis

postgres-advanced-patterns

organvm-iv-taxis

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

数据库 17 8个月前
manutej

Psycopg Skill - Customer Support Tech Enablement

manutej

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

数据库 62 12个月前
manutej

PostgreSQL Database Administration

manutej

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

数据库 62 12个月前
itzikiusa

db-redis

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.

数据库 0 18天前
itzikiusa

db-mysql

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.

数据库 0 18天前
itzikiusa

db-mongodb

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.

数据库 0 18天前
itzikiusa

db-clickhouse

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.

数据库 0 18天前
vuralserhat86

firestore_patterns

vuralserhat86

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

数据库 42 9个月前
dmonteroh

database-migration-orm

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

数据库 1 8个月前
dmonteroh

database-cost-optimization

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

数据库 1 8个月前
ncdevshiv

sqlmap-database-pentesting

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

数据库 1 1个月前
dmonteroh

database-performance

dmonteroh

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

数据库 1 8个月前
dmonteroh

postgresql-engineering

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

数据库 1 8个月前
dmonteroh

database-migration-sql

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

数据库 1 8个月前
dmonteroh

database-architect

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

数据库 1 8个月前
pluginagentmarketplace

postgresql-replication

pluginagentmarketplace

PostgreSQL streaming replication - setup, monitoring, failover

数据库 1 9个月前
pluginagentmarketplace

postgresql-performance

pluginagentmarketplace

Optimize PostgreSQL performance - EXPLAIN ANALYZE, indexing, query tuning

数据库 1 9个月前
pluginagentmarketplace

postgresql-monitoring

pluginagentmarketplace

PostgreSQL monitoring - metrics, alerting, observability

数据库 1 9个月前
pluginagentmarketplace

postgresql-docker

pluginagentmarketplace

PostgreSQL in containers - Docker, Kubernetes, production configs

数据库 1 9个月前
pluginagentmarketplace

postgresql-admin

pluginagentmarketplace

Administer PostgreSQL - security, roles, permissions, maintenance

数据库 1 9个月前
pluginagentmarketplace

postgresql-backup

pluginagentmarketplace

PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR

数据库 1 9个月前