【】ai -claude

mysql 查询sql 创建数据表及数据--1. 创建用户表users-- DROP TABLE IF EXISTS tz_users;CREATE TABLE tz_users(idBIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT用户ID, email VARCHAR(128)NOT NULL COMMENT用户邮箱唯一, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT创建时间, status TINYINT NOT NULL DEFAULT1COMMENT状态1-正常0-禁用2-注销, PRIMARY KEY(id), UNIQUE KEY uk_email(email)-- 邮箱唯一约束)COMMENT用户表;--2. 创建商品表 products -- DROP TABLE IF EXISTS tz_products;CREATE TABLE tz_products(idBIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT商品ID, name VARCHAR(64)NOT NULL COMMENT商品名称, price DECIMAL(10,2)NOT NULL COMMENT商品价格保留2位小数, category VARCHAR(32)NOT NULL COMMENT商品分类, PRIMARY KEY(id))COMMENT商品表;--3. 创建订单表 orders关联用户和商品这里扩展order_items更合理但按你的需求简化 -- DROP TABLE IF EXISTS tz_orders;CREATE TABLE tz_orders(idBIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT订单ID, user_id BIGINT UNSIGNED NOT NULL COMMENT关联用户ID, amount DECIMAL(10,2)NOT NULL COMMENT订单总金额, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT下单时间, status TINYINT NOT NULL DEFAULT0COMMENT订单状态0-待支付1-已支付2-已取消3-已完成, product_id BIGINT UNSIGNED NOT NULL COMMENT产品ID, PRIMARY KEY(id), KEY idx_user_id(user_id), -- 按用户ID查询订单的索引 -- 外键关联用户表可选生产环境可根据业务决定是否启用外键 CONSTRAINT fk_order_user FOREIGN KEY(user_id)REFERENCES tz_users(id)ON DELETE RESTRICT, CONSTRAINT fk_order_product FOREIGN KEY(product_id)REFERENCES tz_product(id))COMMENT订单表;INSERT INTO tz_users(email, created_at, status)VALUES(user1163.com,2026-03-01 10:00:00,1),(user2163.com,2026-03-02 11:00:00,1),(user3163.com,2026-03-03 14:00:00,0);-- 禁用状态的用户 -- 插入商品数据 INSERT INTO tz_products(name, price, category)VALUES(小米14手机,3999.00,手机),(华为MatePad,2499.00,平板),(苹果AirPods Pro,1799.00,耳机),(罗技机械键盘,299.00,外设),(金士顿U盘128G,59.90,存储设备);-- 插入订单数据关联用户ID INSERT INTO tz_orders(user_id, amount, created_at, status,product_id)VALUES(1,3999.00,2026-03-01 10:30:00,3,1), -- user1 已完成的手机订单(1,299.00,2026-03-02 09:15:00,1,4), -- user1 已支付的键盘订单(1,299.00,2026-03-02 09:15:00,1,4), -- user1 已支付的键盘订单(1,59.90,2026-03-02 09:15:00,1,5), -- user1 已支付的键盘订单(2,1799.00,2026-03-03 15:20:00,0,3), -- user2 待支付的耳机订单(3,1799.00,2026-03-04 11:40:00,2,3);-- 禁用用户user3 已取消的平板订单skill -sql在.claude下的skills目录下的sql-query-helper目录下的SKILL.md文件内容--- name: sql-query-helper description:|Helpwriteand optimize SQL queriesforthe company database. Use when Claude needs to query the production database orhelpwith SQL query optimization. ---# SQL Query Helper## Database SchemaOur main tables: -tz_users(id, email, created_at, status)-tz_orders(id, user_id, amount, created_at, status,product_id)-tz_products(id, name, price, category)## Query Guidelines1. Always use parameterized queries2. Include LIMIT clausesforsafety3. Use indexes on WHERE clauses4. Test queriesinstaging first## Common Queries### Active Users\\\sql SELECT id, email, last_login FROM tz_users WHERE statusactiveORDER BY last_login DESC LIMIT100;\\\### Revenue by Month\\\sql SELECT DATE_TRUNC(month, created_at)as month, SUM(amount)as revenue FROM tz_orders WHERE statuscompletedGROUP BY month ORDER BY month DESC;\\\## Notestatus字段的值为1-已支付0-待支付2-禁用3-已完成。status显示时使用文本比如status值为1,则显示为已支付。 If you encounter a TLS/SSL error, please use--skip-sslto skip the verification.使用生新加载重新加载skill:sql-query-helper效果图如下:使用统计分析提示词.ven,查询一下当前订单数据并且分析经营情况生成报告写入到本地请使用本地pip工具的pymysql环境进行查询数据效果图如下查询用户前3条提示词查询用户前3条效果如下