skills.rest
martinholovsky
martinholovskyCOMMUNITY
Explore all skills by this author →
𝕏@martinholovskyGitHub

sota-databases

Audits or designs database layers with ENGINEERING-grade precision for PostgreSQL, MySQL, Redis, and others.

12|2|Updated Jun 17, 2026
Search Tags:#query optimization#security#database#schema#migration#compliance#sql#transaction management
One-click install
npx skills add https://github.com/martinholovsky/SOTA-skills --skill sota-databases
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sota-databases
Source: https://github.com/martinholovsky/SOTA-skills/tree/main/skills/sota-databases
Command: npx skills add https://github.com/martinholovsky/SOTA-skills --skill sota-databases

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, pymysql, redis, pgvector, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill provides expert-level rules for designing, building, and auditing data layers, addressing issues like schema modeling, migrations, query optimization, transaction management, and security. It's ideal for engineers working with databases and seeking to implement best practices.

Core Features & Use Cases

  • Schema Modeling: Guidelines for designing efficient and scalable database schemas.
  • Migration Management: Best practices for writing and reviewing database migrations.
  • Query Optimization: Techniques for crafting efficient queries and indexes.
  • Transaction Management: Guidance on handling transactions and concurrency.
  • Security and Compliance: Recommendations for securing data and ensuring compliance with standards.
  • Use Case: A database engineer can use this Skill to review an existing database for correctness, performance, and security, or to design a new data layer following best practices.

Quick Start

Run the 'sota-databases' skill to perform an audit on the current database schema.

Frequently Asked Questions about sota-databases

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

FAQPage Schema
How do I audit an existing PostgreSQL schema for performance and security issues?▼

To audit a PostgreSQL schema for performance and security, run the Skill in AUDIT mode to evaluate query optimization, schema modeling, transaction management, and compliance against state-of-the-art 2026 database engineering rules.

What are the best practices for writing database migrations to avoid downtime?▼

Best practices for database migrations involve following state-of-the-art rules for schema modeling and migration management, ensuring safe transaction handling and concurrency control during deployment to prevent data layer inconsistencies and downtime.

Can I use this Skill to design a new data layer for vector and AI workloads?▼

Yes, you can use this Skill in BUILD mode to design a new data layer, providing specific guidelines for vector and AI workloads, engine selection, and pgvector integration alongside PostgreSQL for advanced AI-driven applications.

Do I need psycopg2 and pymysql installed to review MySQL and PostgreSQL databases?▼

You need psycopg2 for PostgreSQL connectivity and pymysql for MySQL support, while redis and pgvector dependencies enable comprehensive auditing and building across multiple database systems and vector workloads.

How does transaction management affect database reliability at scale?▼

Transaction management impacts database reliability at scale by governing concurrency control and ACID compliance, with state-of-the-art rules ensuring data integrity under high load and preventing race conditions during parallel operations.

Related Skills

Explore More Software Engineering Skills→
NaveedTechLabNaveedTechLab
11

crm-database-management

Manages PostgreSQL CRM database operations including Alembic migrations, identity resolution, ticket lifecycle, and pgvector search.

Community
Advanced
zhangzhang-111-izhangzhang-111-i
2

database-designer

Analyzes SQL/JSON schemas and generates optimized migration scripts.

Community
Advanced
bomberoxenviosdosruedasbomberoxenviosdosruedas

agency-devops-automator

Automate DevOps workflows with Terraform, GitHub Actions, Kubernetes, and Prometheus.

Community
Advanced
interflownexinterflownex
2

cloud-sql-postgres-monitor

Analyze PostgreSQL performance on Google Cloud SQL using PromQL and pg_stat_activity.

Community
Advanced