tkm:design-database
CommunityDesign and optimize your database schemas and queries.
Authorkhapn-2933
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides comprehensive tools for designing and optimizing database schemas and queries, streamlining the process of building robust, efficient database systems.
Core Features & Use Cases
- Database Schema Design: Offers guidelines for designing transactional (OLTP) and analytical (OLAP) schemas, ensuring consistency, performance, and maintainability.
- Query Writing: Provides references and best practices for writing efficient SQL and MongoDB queries.
- Performance Optimization: Offers techniques for optimizing indexes, query performance, and database maintenance.
- ETL Design: Offers guidelines for incremental data loading and ETL processes with watermarking and control tables.
- Use Case: Imagine you are building a new e-commerce platform. Use this Skill to design your database schema, optimize your queries for fast search and reporting, and implement robust ETL processes for data loading.
Quick Start
Use the tkm:design-database skill to create a new schema for an e-commerce platform with tables for products, customers, orders, and payments.
Dependency Matrix
Required Modules
pymongopsycopg2pandas
Components
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: tkm:design-database Download link: https://github.com/khapn-2933/agentic-coding-hands-on/archive/main.zip#tkm-design-database Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.