Does it show the SQL statement before it runs?

Yes, for security and transparency, the skill is required to print the complete target SQL statement before executing it.

What kind of output format should I expect?

Instead of raw JSON, the skill provides a structured summary including the number of records found and key fields presented in tables or lists.

Can I check the table structure with this skill?

Yes, you can use commands like DESC or SHOW COLUMNS through the skill to inspect the v3_user.organization table schema.

Can I search for organizations using partial names?

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

How does this skill execute SQL queries?

The skill utilizes the 'exec_sql' MCP tool to perform queries against the v3_user database after you provide the necessary parameters.

Database Tenant & Org Manager

Name: Database Tenant & Org Manager
Author: SeSiTing

bySeSiTing

0•

データベース管理

Queries and manages tenant, organization, and factory information within the v3_user database using structured SQL execution.

This skill streamlines the process of retrieving critical organizational metadata from the v3_user database, specifically targeting tenant IDs, factory codes, and organization names. By providing standardized SQL templates and ensuring structured output formatting, it allows developers and administrators to quickly identify and verify tenant-specific configurations. It enforces best practices by requiring a preview of SQL statements before execution and presenting results in a readable, non-JSON format, making database exploration both safer and more efficient.

主な機能

01Flexible search by organization ID, factory code, or display name

02Mandatory SQL preview for verification before execution

03Structured data presentation with clear record counts and field highlighting

04Automated SQL generation for tenant and organization lookups

050 GitHub stars

06Support for schema discovery via column description commands

ユースケース

01Identifying organization IDs based on partial factory names or internal codes

02Auditing organizational structures and database schema details for the v3_user database

03Verifying tenant configuration and factory metadata during system troubleshooting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill