qruiq-cdb-create-db

Provision a MySQL schema and least-privilege app user on Tencent Cloud CDB.

Updated Apr 4, 2026
One-click install
npx skills add https://github.com/qruiqai/qruiq-skills --skill qruiq-cdb-create-db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: qruiq-cdb-create-db
Source: https://github.com/qruiqai/qruiq-skills/tree/main/skills/qruiq-cdb-create-db
Command: npx skills add https://github.com/qruiqai/qruiq-skills --skill qruiq-cdb-create-db

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates provisioning of a new MySQL schema and a dedicated application user on an existing Tencent Cloud CDB instance, returning a ready-to-use connection string and handling common CLI pitfalls.

Core Features & Use Cases

  • Create a new database (schema) with utf8mb4 and a dedicated app user
  • Generate a strong app password locally and avoid leaking secrets
  • Handle tccli argparse issues for '%' in Host by using file-based JSON input
  • Provide an output-ready connection string and guidance for WAN/access control

Quick Start

Create a new schema and a dedicated app user on your existing Tencent CDB MySQL instance and obtain the connection string.

Frequently Asked Questions about qruiq-cdb-create-db

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate creating a MySQL schema and app user on Tencent Cloud CDB?

Automating Tencent Cloud CDB schema and app user creation involves using tccli to provision an isolated database, generate a strong local password, and poll asynchronous operations until completion. This Skill handles the entire workflow and outputs a ready-to-use connection string.

Why does tccli fail when granting app user access with a '%' wildcard host?

The tccli argparse module fails when parsing the '%' wildcard character in the Host parameter. This Skill bypasses the CLI argument parsing issue by utilizing file-based JSON input to safely pass the wildcard host value for granting least-privilege app credentials.

Can I use this automated provisioning approach for isolated schemas across development, testing, and production environments?

Yes, this Skill is specifically designed for scenarios requiring isolated schemas and non-root app credentials across development, testing, and production environments on Tencent Cloud CDB MySQL. It provisions a dedicated app account with least-privilege access for each environment.

What is the best way to securely handle app passwords when provisioning a Tencent CDB database?

The most secure way to handle app passwords during CDB provisioning is generating a strong password locally and avoiding secret leaks. This Skill automates secure password handling without exposing credentials in command line history or logs.

Does creating a Tencent CDB schema and user automatically configure WAN access for my application?

No, creating the schema and user does not automatically configure WAN access. This Skill provisions the database and account, then provides explicit security warnings and WAN access control guidance to ensure you manually configure safe external connection policies.

Do I need root database credentials to create a least-privilege app user on Tencent CDB?

No, you do not use root credentials for the app itself; the goal is to create a dedicated non-root app user. This Skill automates creating a least-privilege account on your existing Tencent CDB instance to ensure applications do not run with root-level permissions.