skills.rest
christopheraaronhogg
christopheraaronhoggCOMMUNITY
Explore all skills by this author →
GitHub

solomon-database

Audit database schemas, queries, and migrations into a structured assessment report.

Updated Feb 28, 2025
Search Tags:#performance#database#schema#migration#query#data-integrity#index
One-click install
npx skills add https://github.com/christopheraaronhogg/codehogg --skill solomon-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: solomon-database
Source: https://github.com/christopheraaronhogg/codehogg/tree/main/templates/skills/solomon-database
Command: npx skills add https://github.com/christopheraaronhogg/codehogg --skill solomon-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides expert database analysis, schema design review, and query optimization assessment to help teams evaluate architecture, performance, and data integrity without writing implementation code.

Core Features & Use Cases

  • Evaluate schema design and normalization to identify inefficiencies and normalization opportunities.
  • Review indexing strategy and query performance to surface optimization opportunities and risk areas.
  • Produce executive-ready assessment reports with findings and prioritized recommendations.
  • Perform migration reviews and data integrity assessments to mitigate risk and plan improvements.

Quick Start

Run a targeted database assessment by specifying the project context to generate a structured report.

Frequently Asked Questions about solomon-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I audit database schemas and queries to identify optimization opportunities?▼

Database schema and query audits evaluate normalization, indexing strategies, and performance to surface optimization opportunities. The process generates a structured assessment report detailing findings, severity levels, and prioritized remediation steps with concrete references to specific tables and queries.

What is database migration review and when do I need it?▼

Database migration review analyzes migration patterns to identify risk factors and data integrity issues. You need it when planning schema changes across projects to mitigate risk, evaluate architecture stability, and receive prioritized recommendations for improvement before deployment.

How do I review indexing strategy and query performance for risk areas?▼

Reviewing indexing strategy and query performance analyzes database schemas to surface optimization opportunities and risk areas. The assessment produces an executive-ready report with structured findings, severity ratings, and concrete remediation steps referencing specific tables and queries.

Can I assess database data integrity and schema design without writing implementation code?▼

Yes, database data integrity and schema design assessments evaluate normalization and inefficiencies without writing implementation code. The analysis identifies risk factors across projects and delivers a comprehensive report detailing findings and prioritized remediation steps.

What's the best way to evaluate database architecture and performance across projects?▼

Evaluating database architecture and performance requires auditing schemas, queries, and migrations to produce a comprehensive assessment report. This approach identifies optimization opportunities and risk factors, delivering prioritized remediation steps with concrete references to affected database objects.

Related Skills

Explore More Data & Analytics Skills→
StrategicMilkStrategicMilk

Database Schema Analysis

Analyze SQLite, PostgreSQL, or ORM schemas and output a JSON report.

Community
Intermediate
zero3041zero3041
1

postgres-patterns

Optimize PostgreSQL query performance, schema design, indexing, and security.

Community
Advanced
ntk148vntk148v
42

altinity-expert-clickhouse-expert

Diagnose ClickHouse server health issues by analyzing logs, metrics, and query patterns.

Community
Advanced
crgarcia12crgarcia12

performance-assessment

Analyze code statically to identify performance bottlenecks and generate impact-rated reports.

Community
Advanced