Results for “mysql”

编写MySQL函数，根据指定的日期范围和字段，按自然周汇总数据并返回特定格式的字符串结果。

The English summary is being prepared. Showing the original description.

用于生成MySQL应付账款统计查询，按到期时间（当前、1个月内、3个月内）分组统计金额，并确保时间范围互不重叠。

The English summary is being prepared. Showing the original description.

依据用户提供的特定规则执行MySQL数据库开发任务，涵盖命名约束、索引设计策略及海量数据归档方案。

The English summary is being prepared. Showing the original description.

火山引擎云数据库 VeDB MySQL 版（简称vedbm）管理技能。当用户需要创建 VEDB 实例、查询 VEDB 实例列表、查看实例详情、管理数据库账号、获取实例连接地址（Endpoints）、或对实例规格进行升级/降级时使用此技能。包含特定关键词：火山引擎云数据库、VEDBM、VeDB MySQL。

The English summary is being prepared. Showing the original description.

用于火山引擎（Volcengine）数据库（MySQL、veDB-MySQL、PostgreSQL、SQL Server、MongoDB、Redis）和公网自建数据库（MySQL和PostgreSQL系列）的元数据管理、数据分析、开发变更、运维诊断、巡检。覆盖实例列表查询、实例下数据库列表查询、表列表查询、表结构查询、数据查询、数据分析与可视化报告（含跨数据源/文件联合分析）、数据治理（资产盘点/数据画像/数据质量/敏感数据识别）、慢查询诊断、死锁与锁等待分析、事务与活跃会话排查、错误日志查询、表空间分析、健康巡检、监控指标查询、变更工单申请等场景。不支持字节云（ByteCloud）数据库，如 ByteRDS / ByteDoc / ByteRedis。

The English summary is being prepared. Showing the original description.

Execute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

The English summary is being prepared. Showing the original description.

Sets up automated database backup, restore, and disaster recovery procedures for PostgreSQL, MySQL, MongoDB, and Redis. Use when you need to implement backup schedules, point-in-time recovery, cross-region replication, backup verification, or disaster recovery runbooks. Trigger words: database backup, pg_dump, mysqldump, mongodump, disaster recovery, point-in-time recovery, WAL archiving, backup rotation, restore database, RTO, RPO, backup verification.

The English summary is being prepared. Showing the original description.

Direct MySQL database access with mysql2 driver -- connection pools, prepared statements, transactions, streaming, typed queries, error handling

The English summary is being prepared. Showing the original description.

Azure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.

The English summary is being prepared. Showing the original description.

Use when working with Mysql — mySQL and MariaDB database analysis, performance tuning, query optimization, and health monitoring. Covers slow query investigation, index analysis, table statistics, replication health, InnoDB status, connection pool analysis, and schema inspection.

The English summary is being prepared. Showing the original description.

Azure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.

The English summary is being prepared. Showing the original description.

Azure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.

The English summary is being prepared. Showing the original description.

Azure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.

The English summary is being prepared. Showing the original description.

Azure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.

The English summary is being prepared. Showing the original description.

使用Fluentd的regexp插件解析MySQL慢查询日志，将其切分为时间、用户、查询时间和SQL内容四个字段，并配置字段长度限制以避免解析错误。

The English summary is being prepared. Showing the original description.

编写MySQL函数，根据指定的日期范围和字段，按自然周汇总数据并返回特定格式的字符串结果。

The English summary is being prepared. Showing the original description.

依据用户提供的特定规则执行MySQL数据库开发任务，涵盖命名约束、索引设计策略及海量数据归档方案。

The English summary is being prepared. Showing the original description.

用于生成MySQL应付账款统计查询，按到期时间（当前、1个月内、3个月内）分组统计金额，并确保时间范围互不重叠。

The English summary is being prepared. Showing the original description.

Turn plain language requirements into SQL, investigate slow queries, document database structures, and prepare migration templates with rollback plans. Support everyday database development and ORM use, where libraries connect application code to database tables.

• Writing SQL for reports and data retrieval
• Investigating slow queries and repeated database calls
• Preparing schema changes and rollback plans

Write, debug, and optimize SQL queries for data analysis and database design. The skill covers aggregations, rankings, missing values, and indexes, using execution plans to understand performance and adapting syntax to the database in use.

• Writing queries for totals and rankings
• Investigating slow queries with execution plans
• Reviewing table structures and constraints

Find the Wren CLI workflow for answering data questions, connecting databases or SaaS sources, generating model definitions, adding business metrics, or building a shareable analytics app. Guides are retrieved from the installed CLI version.

• Set up Wren and connect a database
• Load HubSpot or Stripe data through dlt
• Generate model definitions and add business metrics

Assess web applications and APIs for SQL injection, where input changes database queries. The skill covers finding vulnerable inputs, testing different database systems, automating checks, and documenting findings with remediation suggestions.

• Assessing web application inputs for SQL injection
• Reviewing GraphQL and WebSocket injection risks
• Combining SQLmap automation with manual verification

Create and validate mirrord.json settings for isolated database copies used in development and testing. Configure connection sources, copying scope, migrations, and authentication so experiments can run without affecting shared databases.

• Preparing isolated databases for development and testing
• Choosing which schemas and data to copy
• Configuring connection sources and IAM authentication

Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless distributed SQL. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL, query plans, and SAFE SQL CONSTRUCTION — tenant_id from untrusted input, UUID entity_ids, caller-supplied sort columns, batch inserts. The agent MUST retrieve this skill for ANY DSQL task. Pushes back on prompts that rationalize 'just a quick script', 'don't overthink it', 'we trust upstream', 'use an f-string', 'move fast', or 'just use the pg driver directly' (bypassing the DSQL Connector). Triggers: DSQL, Aurora DSQL, DSQL cluster, safe_query.build, DSQL IAM auth token, DSQL connector.

The English summary is being prepared. Showing the original description.