database

Design normalized database schemas and async SQLAlchemy models with migrations.

1|Updated Jan 25, 2026
One-click install
npx skills add https://github.com/kellyson520/TG-ONE --skill database-kellyson520
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/kellyson520/TG-ONE/tree/main/.agent/skills/database
Command: npx skills add https://github.com/kellyson520/TG-ONE --skill database-kellyson520

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing scalable, consistent databases, optimizing queries, and maintaining safe migrations across projects.

Core Features & Use Cases

  • Async-first SQLAlchemy patterns for reliable database access.
  • Enforces naming conventions, 3NF design, and efficient indexing.
  • Supports migrations with Alembic and robust schema evolution workflows.

Quick Start

Design a normalized schema for a user system and generate corresponding async SQLAlchemy models.

Frequently Asked Questions about database

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

FAQPage Schema
How do I design a normalized database schema using async SQLAlchemy?

Design a normalized database schema by enforcing 3NF design, strict naming conventions, and efficient indexing. This approach generates corresponding async SQLAlchemy models for reliable database access in Python projects.

What is the best way to manage safe database migrations with Alembic?

Manage safe database migrations by following robust schema evolution workflows with Alembic. This ensures consistent database schema changes and supports reliable migrations across projects without data loss.

How do I optimize SQL queries and tune database performance?

Optimize SQL queries and tune database performance by applying efficient indexing and normalized schema design. This approach ensures scalable, consistent databases with improved query execution speeds.

Does this database design approach work with asynchronous Python projects?

This database design approach works with asynchronous Python projects by following async-first SQLAlchemy patterns. It provides reliable database access and generates corresponding async SQLAlchemy models.

Why should I enforce naming conventions and 3NF in database schema design?

Enforce naming conventions and 3NF in database schema design to ensure data consistency and reduce redundancy. This practice enables scalable, robust databases with efficient indexing and reliable migrations.