What database does this skill interact with?

This skill is specifically designed to query the v3_user database, focusing on organization and tenant information tables.

Can I search for factories by partial name?

Yes, the skill supports fuzzy matching using LIKE queries for both factory codes and organization names.

Does this skill require a specific tool?

Yes, it requires the exec_sql MCP tool to be available and configured in your Claude Code environment.

How is the query data presented?

The skill automatically formats raw database records into human-readable tables or lists, highlighting key fields like Tenant ID and Factory Code.

Is it possible to see the SQL before it runs?

Yes, as a safety and transparency measure, the skill is configured to print the full SQL statement before executing the query.

Blacklake User & Organization DB Query

Name: Blacklake User & Organization DB Query
Author: SeSiTing

bySeSiTing

0•

データベース管理

Queries tenant and organizational data from the v3_user database using standardized SQL templates and structured reporting.

The db-user skill empowers Claude to interact specifically with the v3_user database to retrieve vital tenant and factory information. It streamlines the workflow for developers and support teams by providing pre-defined SQL templates for searching organizations by ID, code, or name. The skill ensures transparency and readability by requiring SQL statement logging before execution and transforming raw JSON query results into clear, structured tables or lists, making it easier to analyze factory configurations and tenant hierarchies without manually parsing raw data.

主な機能

01Structured data formatting for clear presentation of query results

020 GitHub stars

03Seamless integration with the exec_sql MCP tool

04Multi-parameter search by ID, Factory Code, or Organization Name

05Automated SQL generation for tenant and organization lookups

06Mandatory SQL logging for execution transparency and debugging

ユースケース

01Identifying specific tenant details during troubleshooting or support sessions

02Locating factory information based on partial names or internal codes

03Auditing organization structures within the v3_user database schema

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sesiting/siti-claude-marketplace db-user

For use in Claude.ai and ChatGPT

Download Skill