Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,700
pages available: 196

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 2,209–2,232 of 4,700 skills

Managing RisingwaveAUse when working with Risingwave — risingWave streaming database management — monitor sources, sinks, materialized views, clusters, query performance, and ingestion health. Use when debugging stream processing lag, inspecting view dependencies, auditing data freshness, or reviewing cluster capacity.databasesbashsqlVotes: 0GitHub stars: 6
Managing QuestdbAUse when working with Questdb — questDB time-series database management — monitor tables, partitions, ingestion throughput, query performance, and server health. Use when inspecting table schemas, debugging slow queries, reviewing WAL status, or auditing storage utilization.databasesbashdebuggingVotes: 0GitHub stars: 6
Managing OuterbaseAUse when working with Outerbase — outerbase database interface management covering workspace inventory, connected database sources, table schemas, query history, saved queries, API endpoint generation, dashboard configurations, and user access controls. Use for managing Outerbase-connected database environments.databasesbashsqlVotes: 0GitHub stars: 6
Gcp Cloud SpannerAUse when working with Gcp Cloud Spanner — google Cloud Spanner instance management, query statistics analysis, hot spot detection, schema analysis, and performance diagnostics via gcloud CLI.databasesgobashVotes: 0GitHub stars: 6
Gcp AlloydbAUse when working with Gcp Alloydb — google AlloyDB cluster management, instance analysis, query insights, maintenance window configuration, and performance diagnostics via gcloud CLI.databasesgobashVotes: 0GitHub stars: 6
Aws Rds DeepAUse when working with Aws Rds Deep — aWS RDS deep analysis covering Performance Insights, event subscriptions, proxy management, and global database status. Covers PI counter metrics, wait event analysis, top SQL queries, read replica lag, storage autoscaling, and Aurora-specific diagnostics.databasesgobashVotes: 0GitHub stars: 6
Analyzing PostgresAPostgreSQL database analysis, performance tuning, and health monitoring. You MUST read this entire skill document before executing any PostgreSQL operations — it contains mandatory workflows, safety constraints, and two-phase execution rules that prevent common errors like hallucinated column names and unsafe queries.databasestypescriptgoVotes: 0GitHub stars: 6
Analyzing Neo4jAUse when working with Neo4J — neo4j graph database analysis, index management, Cypher query optimization, APOC utilities, and cluster health monitoring.databasesshellbashVotes: 0GitHub stars: 6
Analyzing MysqlAUse when working with Mysql — mySQL and MariaDB database analysis, performance tuning, query optimization, and health monitoring. Covers slow query investigation, index analysis, table statistics, replication health, InnoDB status, connection pool analysis, and schema inspection.databasesbashsqlVotes: 0GitHub stars: 6
Analyzing CockroachdbAUse when working with Cockroachdb — cockroachDB cluster health, range distribution, SQL statistics, schema change monitoring, and query optimization.databasesgoshellVotes: 0GitHub stars: 6
Analyzing AlloydbAUse when working with Alloydb — google AlloyDB instance analysis, query insights, columnar engine optimization, maintenance windows, and cluster health.databasesgoshellVotes: 0GitHub stars: 6
Cryptography Pqc StandardsAAtua como especialista sênior em Engenharia Criptográfica, Criptografia Pós-Quântica (PQC FIPS 203/204/205), Infraestrutura de Chaves Públicas (PKI X.509v3), Gestão de Chaves (DEK/KEK, Envelope Encryption, KMS/HSM), Assinaturas Digitais (CAdES, XAdES, PAdES, JAdES, eIDAS, ICP-Brasil), Criptografia em Repouso (FDE, XTS-AES, TDE), Criptografia Avançada (Homomórfica FHE, FPE, ZKP, MPC/Threshold FROST) e Protocolos de Transporte Seguro (TLS 1.3, ECH, mTLS, QUIC, WireGuard, IPsec).databasesgobashVotes: 0GitHub stars: 10
Software ArchitectAAtua como Arquiteto de Software aplicando engenharia de baixo nível, princípios SOLID, DDD, decisões de topologia de sistemas, testabilidade e orquestração de Design Patterns.databasesgosqlVotes: 0GitHub stars: 10
Dba Database AdministratorAFornece padrões de engenharia de software e administração de bancos de dados (DBA) para sistemas SQL e NoSQL. Cobre modelagem de dados, estratégias de indexação, otimização de consultas (EXPLAIN), controle de concorrência (ACID/BASE), replicação, alta disponibilidade, backups (PITR), conexões TLS seguras por padrão e segurança em PostgreSQL, MariaDB, SQLite e MongoDB.databasesgosqlVotes: 0GitHub stars: 10
Db Schema Reverse MappingAEspecialista em Mapeamento de Bancos de Dados, Engenharia Reversa de Esquemas (ERD), Análise de Dependências de I/O e Profiling de Consultas utilizando SchemaSpy, DbSchema, DBeaver, pgModeler, ERBuilder, SQL Power Architect, pgBadger, Percona PMM e SSDT.databasesgojavaVotes: 0GitHub stars: 10
App Dependency DiscoveryAEspecialista em Descoberta de Aplicações, Rastreamento Distribuído (Distributed Tracing), Service Maps e Telemetria Kernel/eBPF utilizando OpenTelemetry (OBI), Caretta, Jaeger, Zipkin, Apache SkyWalking, SigNoz e Grafana Tempo.databasespythongoVotes: 0GitHub stars: 10
Linguistic Pt BrAEspecialista em Revisão e Redação em Português Brasileiro (PT-BR), focado em clareza técnica, precisão semântica, norma culta contemporânea, eliminação de ambiguidades, erradicação de vícios de IA e adaptação ao público humano.databasesgojavaVotes: 0GitHub stars: 10
Lang PythonAFornece padrões de engenharia de software em Python 3 baseados na documentação oficial (docs.python.org/pt-br/3), cobrindo o Zen do Python (PEP 20), guia de estilo (PEP 8), Data Model (__dunder__), Pattern Matching (PEP 634), Tipagem Avançada (PEP 484/695), Asyncio, Biblioteca Padrão e frameworks modernos.databasespythongoVotes: 0GitHub stars: 10
Lang GoAFornece padrões de engenharia de software em Go (Golang) baseados na documentação oficial (go.dev/doc), Effective Go, Go Memory Model e boas práticas de concorrência (goroutines, channels, context), tratamento de erros, genéricos, módulos e testes.databasespythongoVotes: 0GitHub stars: 10
Framework Spring BootAFornece padrões de engenharia e arquitetura para aplicações corporativas com Spring Boot 3.x+, cobrindo Spring MVC REST, injeção de dependências por construtor, DTOs imutáveis (Records), Virtual Threads (Loom), validação, Spring Data JPA e testes com Testcontainers.databasesjavasqlVotes: 0GitHub stars: 10
Framework CriterionAAtua como Especialista em testes unitários para a linguagem C utilizando Criterion, cobrindo macros Test, cr_assert/cr_expect, ciclos de vida (.init/.fini), teste de sinais/crashes, captura de stdout/stderr e integração com CMake.databasesgosqlVotes: 0GitHub stars: 10
Realtime Streaming Event DrivenAEspecialista em Arquiteturas de Streaming em Tempo Real, Unificação Batch-Stream e Bancos de Dados de Streaming baseado nas obras Streaming Databases (Hubert Dulay) e Building Real-Time Analytics Systems (Mark Needham). Cobre Apache Kafka, Apache Pinot, Apache Flink, ClickHouse, Change Data Capture (CDC via Debezium) e consultas OLAP em tempo real com sub-segundo de latência.databasessqlapiVotes: 0GitHub stars: 10
Jpa Hibernate PerformanceAEspecialista em Performance de Persistência Java (JPA/Hibernate) baseado em High-Performance Java Persistence (Vlad Mihalcea). Cobre JDBC batching, N+1 query problem e fetch strategies (JOIN FETCH, EntityGraph), FlushOperationQueue e ActionQueue, dirty checking, cache de primeiro e segundo nível (read-through/nonstrict-read-write), locking otimista/pessimista, paginação eficiente (keyset vs OFFSET), transações e isolamento, e tuning SQL por banco (EXPLAIN, execution plans).databasesgojavaVotes: 0GitHub stars: 10
Db PostgresqlAFornece padrões de administração e engenharia para PostgreSQL baseizados na documentação oficial (postgresql.org/docs). Cobre arquitetura MVCC, tunagem de Autovacuum, tipos avançados (JSONB, PostGIS), estratégia de índices (B-Tree, GIN, GiST, BRIN), análise EXPLAIN ANALYZE BUFFERS, replicação e PgBouncer.databasespythonrustVotes: 0GitHub stars: 10