skills.rest
chinawrj
chinawrjCOMMUNITY
Explore all skills by this author →
GitHub

db-manager

Automate A-share database lifecycle management via manage.py and DuckDB recovery.

Updated Jan 12, 2026
Search Tags:#automation#database#maintenance#recovery#duckdb#stock-data#a-share
One-click install
npx skills add https://github.com/chinawrj/agent-skills-stock --skill db-manager-chinawrj
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-manager
Source: https://github.com/chinawrj/agent-skills-stock/tree/main/.github/skills/db-manager
Command: npx skills add https://github.com/chinawrj/agent-skills-stock --skill db-manager-chinawrj

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb.

What problem does it solve?

A股数据库的建库到日常运维过程繁杂、易出错，需统一入口与可重复的工作流。

Core Features & Use Cases

  • 提供从零建库到日常维护的端到端流程集合，覆盖表结构创建、数据导入、日常更新、周度维护、健康检查以及缓存重建。
  • 支持通过 cache 文件驱动数据重建和快速恢复，降低数据损坏带来的停机风险。
  • 提供内置健康检查和修复机制，帮助团队及时发现并修复数据异常。

Quick Start

Initialize the A-share database from scratch using manage.py init, then perform daily updates and weekly maintenance as needed.

Frequently Asked Questions about db-manager

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

FAQPage Schema
How do I automate A-share stock database initialization and daily market updates?▼

You can automate A-share database initialization and daily market updates through a deterministic orchestration entry point, managing table creation, data import, and routine updates in a unified workflow.

What is the best way to recover a locked DuckDB instance during database maintenance?▼

The best way to recover a locked DuckDB instance is using cache-driven rebuild workflows and built-in recovery procedures, which restore data integrity and minimize downtime without manual intervention.

Does this database maintenance workflow support weekly health checks for stock data pipelines?▼

Yes, the database maintenance workflow supports weekly health checks for stock data pipelines, providing built-in mechanisms to detect anomalies and execute repair procedures across the pipeline.

Can I rebuild a corrupted A-share database from cache files instead of starting from scratch?▼

Yes, you can rebuild a corrupted A-share database from cache files, which drive data reconstruction workflows to lower downtime risks and quickly restore the database to a functional state.

Do I need DuckDB installed to run the A-share database build and maintenance tasks?▼

Yes, DuckDB is a required dependency to run the A-share database build and maintenance tasks, serving as the underlying engine for data storage, health checks, and recovery procedures.

Why does deterministic orchestration matter for A-share database lifecycle management?▼

Deterministic orchestration matters because it provides a repeatable and unified entry point for the entire A-share database lifecycle, preventing manual errors during complex daily updates and weekly maintenance routines.

Related Skills

Explore More Data & Analytics Skills→
nq-rdlnq-rdl

install-duckdb

Install or update DuckDB extensions and the CLI in automation pipelines.

Official
Intermediate
vathymutvathymut

duckdb

Execute SQL queries and analyze spatial data with DuckDB.

Community
Advanced
huidgehuidge
2

a-share-report-akshare

Automate A-share daily and weekly market reports from Eastmoney and AKShare data.

Community
Intermediate
Khoatran1999Khoatran1999

databases

Design schemas, optimize queries, and manage maintenance for MongoDB and PostgreSQL.

Community
Advanced