鱼皮AI导航
鱼皮AI导航
  • 主页
  • 社区
  • AI工具
  • AI知识库
  • AI提示词
  • MCP
  • Skills
  • AI学习资源
  • AI资讯
  • GitHub开源
登录/注册

skill-adapter

面向超大规模数据库表的自动化分区管理,支持按时间范围、枚举值或哈希方式设计分区策略,优化查询性能与维护效率,适用于物联网日志、订单历史等时序或高增长场景,并提供数据归档与生命周期管控能力。

数据与分析数据库
访问 GitHub
文档Skills.MD
name
Managing Database Partitions
description
This skill enables Claude to design, implement, and manage table partitioning strategies for large databases. It is triggered when the user needs to optimize query performance, manage time-series data, or reduce maintenance windows for tables exceeding 100GB. Use this skill when asked to "create database partitions", "optimize database queries with partitioning", "manage large database tables", or when the user mentions "partitioning strategy", "data archival", or uses the command `/partition`. The skill helps automate partition maintenance and data lifecycle management. It focuses on database best practices and production-ready implementations.

Overview

This skill automates the design, implementation, and management of database table partitioning strategies. It helps optimize query performance, manage time-series data, and reduce maintenance windows for massive datasets.

How It Works

  1. Analyze Requirements: Claude analyzes the user's request to understand the specific partitioning needs, including data size, query patterns, and maintenance requirements.
  2. Design Partitioning Strategy: Based on the analysis, Claude designs an appropriate partitioning strategy (e.g., range, list, hash) and determines the optimal partition key.
  3. Implement Partitioning: Claude generates the necessary SQL scripts or configuration files to implement the partitioning strategy on the target database.
  4. Optimize Queries: Claude provides guidance on optimizing queries to take advantage of the partitioning scheme, including suggestions for partition pruning and index creation.

When to Use This Skill

This skill activates when you need to:

  • Manage tables exceeding 100GB with slow query performance.
  • Implement time-series data archival strategies (IoT, logs, metrics).
  • Optimize queries that filter by date ranges or specific values.
  • Reduce database maintenance windows.

Examples

Example 1: Optimizing Time-Series Data

User request: "Create database partitions for my IoT sensor data to improve query performance."

The skill will:

  1. Analyze the data schema and query patterns for the IoT sensor data.
  2. Design a range-based partitioning strategy using the timestamp column as the partition key.
  3. Generate SQL scripts to create partitioned tables and indexes.

Example 2: Managing Large Order History Table

User request: "Implement table partitioning for my order history table to reduce maintenance window."

The skill will:

  1. Analyze the size and growth rate of the order history table.
  2. Design a list-based partitioning strategy based on order status or region.
  3. Generate SQL scripts to create partitioned tables and migrate existing data.

Best Practices

  • Partition Key Selection: Choose a partition key that is frequently used in queries and evenly distributes data across partitions.
  • Partition Size: Determine the optimal partition size based on query patterns and storage capacity.
  • Maintenance: Implement automated partition maintenance tasks, such as creating new partitions and archiving old partitions.

Integration

This skill can be integrated with other database management tools for monitoring partition performance and managing data lifecycle. It can also work with data migration tools to efficiently move data between partitions.

数据与分析
数据库

快捷安装

复制到终端去安装 Skill

npxskillsaddjeremylongshore/claude-code-plugins-plus-skills--skill"skill-adapter"
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
🔥热门工具
朱雀AI检测朱雀AI检测
朱雀AI检测助手朱雀AI检测助手
LovartLovart
老鱼简历老鱼简历
WritePass官网WritePass官网
面多多面多多
CursorCursor
星月写作星月写作
朱雀AI检测助手朱雀AI检测助手
零感AI零感AI
Skills 推荐
definition-of-done-generator
自动生成项目完成标准的规范定义与配置文件,提供符合企业级工作流要求的最佳实践指导,输出可直接投入生产环境的代码和验证结果,适用于需要标准化流程审批、合规审查及跨系统集成的复杂项目管理场景。
sagemaker-endpoint-deployer
自动化部署机器学习模型至云端服务端点,支持从配置生成到生产验证的全流程,适用于模型上线、服务监控与推理优化等场景,确保部署方案符合工业级标准。
docx
支持专业级 Word 文档的全生命周期处理,包括从零创建结构化文档、精准编辑内容、管理修订痕迹与批注、提取纯文本或原始 XML 数据、转换为 PDF 或图像用于视觉分析,适用于法律、学术及企业场景下的高保真文档协作与自动化处理。
skills-search
提供对 Claude Code 技能生态的全周期管理能力,支持按功能关键词检索技能、查看详细信息、安装或卸载指定技能,并区分用户级与项目级作用域,覆盖发现、评估、部署及维护各环节。
moai-foundation-core
构建高质量、可扩展的AI开发工作流,通过领域驱动设计与模块化架构实现需求规范先行,结合自动化质量门禁、精细化上下文管理与渐进式知识呈现,在保障安全与可维护性的同时提升开发效率与协作清晰度。