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

Database Management

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

About

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.

Key Features

Structured data formatting for clear presentation of query results
0 GitHub stars
Seamless integration with the exec_sql MCP tool
Multi-parameter search by ID, Factory Code, or Organization Name
Automated SQL generation for tenant and organization lookups
Mandatory SQL logging for execution transparency and debugging

Use Cases

Identifying specific tenant details during troubleshooting or support sessions
Locating factory information based on partial names or internal codes
Auditing organization structures within the v3_user database schema

About

Key Features

Structured data formatting for clear presentation of query results
0 GitHub stars
Seamless integration with the exec_sql MCP tool
Multi-parameter search by ID, Factory Code, or Organization Name
Automated SQL generation for tenant and organization lookups
Mandatory SQL logging for execution transparency and debugging

Use Cases

Identifying specific tenant details during troubleshooting or support sessions
Locating factory information based on partial names or internal codes
Auditing organization structures within the v3_user database schema