What database does this skill target?

It specifically targets the v3_e-report database, focusing on tables like analysis_config used for data analysis and alerting.

How does the skill ensure data accuracy?

It automatically appends 'deleted_at = 0' to queries to filter out logically deleted records and enforces SQL printing before execution for verification.

Can I use this for non-SQL tasks?

No, this skill is specifically designed for database interaction and reporting using the exec_sql tool within the Claude Code environment.

How are the query results displayed?

The skill avoids raw JSON output, instead presenting data in structured tables or lists to make the results easier for humans to read and analyze.

Does it support custom table queries?

While it provides specific templates for analysis_config, it includes commands like DESC and SHOW COLUMNS to help users explore other tables in the v3_e-report database.

Blacklake E-Report DB Assistant

Name: Blacklake E-Report DB Assistant
Author: SeSiTing

bySeSiTing

数据库管理

Provides SQL query templates and automated reporting for the v3_e-report database to manage and analyze alert configurations.

关于

The db-e-report skill streamlines the process of querying the Blacklake v3_e-report database, specifically focusing on the analysis_config table. It allows developers and data analysts to quickly retrieve alert configuration details, count active rules, and monitor tenant-specific data analysis settings. By enforcing best practices like pre-printing SQL statements and formatting results into structured tables, it ensures clear, error-free database interaction and observability within the Claude Code environment.

主要功能

Structured data visualization using tables and lists instead of raw JSON
Pre-defined SQL templates for the analysis_config table
Automatic filtering for active records using the deleted_at = 0 condition
0 GitHub stars
Support for tenant-specific (org_id) configuration lookups
Integrated counting of published alert rules and unique tenants

使用场景

Debugging specific alert configuration issues by querying ID and status
Auditing data analysis alert configurations across multiple tenants
Generating statistical reports on the number of active alert rules

关于

主要功能

Structured data visualization using tables and lists instead of raw JSON
Pre-defined SQL templates for the analysis_config table
Automatic filtering for active records using the deleted_at = 0 condition
0 GitHub stars
Support for tenant-specific (org_id) configuration lookups
Integrated counting of published alert rules and unique tenants

使用场景

Debugging specific alert configuration issues by querying ID and status
Auditing data analysis alert configurations across multiple tenants
Generating statistical reports on the number of active alert rules