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

0•

数据库管理

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.

主要功能

01Structured data visualization using tables and lists instead of raw JSON

02Pre-defined SQL templates for the analysis_config table

03Automatic filtering for active records using the deleted_at = 0 condition

040 GitHub stars

05Support for tenant-specific (org_id) configuration lookups

06Integrated counting of published alert rules and unique tenants

使用场景

01Debugging specific alert configuration issues by querying ID and status

02Auditing data analysis alert configurations across multiple tenants

03Generating statistical reports on the number of active alert rules

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sesiting/siti-claude-marketplace db-e-report

For use in Claude.ai and ChatGPT

Download Skill