Chat2Db
Chat2Db
by bytesagain
AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL db-chat, java, ai, bi, chatgpt, clickhouse.
安装
claude skill add --url github.com/openclaw/skills/tree/main/skills/bytesagain/db-chat文档
Db Chat
Db Chat v2.0.0 — a social/communication toolkit for managing connections, syncing data, monitoring activity, automating tasks, and more from the command line.
Commands
Run via: bash scripts/script.sh <command> [args]
| Command | Description |
|---|---|
connect <input> | Log a connection entry (e.g., new contact, service link). Without args, shows recent entries. |
sync <input> | Record sync operations or data synchronization notes. |
monitor <input> | Log monitoring entries — track what you're watching or observing. |
automate <input> | Record automation tasks or scripted workflows. |
notify <input> | Log notification entries — messages, alerts, pings. |
report <input> | Create or view report entries for summaries and analysis. |
schedule <input> | Log scheduled items — meetings, events, recurring tasks. |
template <input> | Save or view template entries for reusable patterns. |
webhook <input> | Record webhook configurations or event triggers. |
status <input> | Log status updates or check-ins. |
analytics <input> | Record analytics data points and observations. |
export <input> | Log export operations or data transfer records. |
stats | Show summary statistics across all entry types. |
export <fmt> | Export all data in json, csv, or txt format. |
search <term> | Search across all log files for a keyword. |
recent | Show the 20 most recent activity entries from the history log. |
help | Show the built-in help message with all available commands. |
version | Print the current version (db-chat v2.0.0). |
Each data command works in two modes:
- With arguments: saves the input with a timestamp to its dedicated log file.
- Without arguments: displays the 20 most recent entries from that log.
Data Storage
All data is stored locally in ~/.local/share/db-chat/:
- Each command has its own log file (e.g.,
connect.log,sync.log,monitor.log) - Entries are saved in
timestamp|valueformat - A unified
history.logrecords all activity across commands - Export files are written to the same directory
Requirements
- Bash (standard system shell)
- No external dependencies — uses only coreutils (
date,wc,du,grep,tail,cat)
When to Use
- When you need to log database connections or service links from the terminal
- To track sync operations and data synchronization events
- For monitoring and recording automation workflows
- To manage notification logs and webhook configurations
- When you want to schedule and template recurring tasks
- To export activity data for reporting or backup purposes
- For lightweight, file-based activity and communication tracking
Examples
# Log a new connection
db-chat connect "Connected to production MySQL replica"
# Record a sync operation
db-chat sync "Synced user table from staging to dev"
# Log a monitoring entry
db-chat monitor "CPU usage spike on db-primary at 14:30"
# Set up an automation record
db-chat automate "Nightly backup script configured for 2am"
# Log a notification
db-chat notify "Alert: disk usage exceeded 90% on db-02"
# Schedule something
db-chat schedule "Weekly standup every Monday 10am"
# Save a template
db-chat template "SELECT * FROM users WHERE created_at > NOW() - INTERVAL 7 DAY"
# Record a webhook
db-chat webhook "POST /api/hooks/deploy — triggers on push to main"
# View all statistics
db-chat stats
# Export everything as CSV
db-chat export csv
# Search for entries mentioning "backup"
db-chat search backup
# Check recent activity
db-chat recent
Powered by BytesAgain | bytesagain.com | hello@bytesagain.com
相关 Skills
技术栈评估
by alirezarezvani
对比框架、数据库和云服务,结合 5 年 TCO、安全风险、生态活力与迁移复杂度做量化评估,适合技术选型、栈升级和替换路线决策。
✎ 帮你系统比较技术栈优劣,不只看功能,还把TCO、安全性和生态健康度一起量化,选型和迁移决策更稳。
资深数据科学家
by alirezarezvani
覆盖实验设计、特征工程、预测建模、因果推断与模型评估,适合用 Python/R/SQL 做 A/B 测试、时序分析和生产级 ML 落地,支撑数据驱动决策。
✎ 从 A/B 测试、因果分析到预测建模一条龙搞定,既有硬核统计方法也懂业务沟通,特别适合把数据结论真正落地。
资深架构师
by alirezarezvani
适合系统设计评审、ADR记录和扩展性规划,分析依赖与耦合,权衡单体或微服务、数据库与技术栈选型,并输出Mermaid、PlantUML、ASCII架构图。
✎ 搞系统设计、技术选型和扩展规划时,用它能更快理清架构决策与依赖关系,还能直接产出 Mermaid/PlantUML 图,方案讨论效率很高。
相关 MCP 服务
SQLite 数据库
编辑精选by Anthropic
SQLite 是让 AI 直接查询本地数据库进行数据分析的 MCP 服务器。
✎ 这个服务器解决了 AI 无法直接访问 SQLite 数据库的问题,适合需要快速分析本地数据集的开发者。不过,作为参考实现,它可能缺乏生产级的安全特性,建议在受控环境中使用。
PostgreSQL 数据库
编辑精选by Anthropic
PostgreSQL 是让 Claude 直接查询和管理你的数据库的 MCP 服务器。
✎ 这个服务器解决了开发者需要手动编写 SQL 查询的痛点,特别适合数据分析师或后端开发者快速探索数据库结构。不过,由于是参考实现,生产环境使用前务必评估安全风险,别指望它能处理复杂事务。
Firecrawl 智能爬虫
编辑精选by Firecrawl
Firecrawl 是让 AI 直接抓取网页并提取结构化数据的 MCP 服务器。
✎ 它解决了手动写爬虫的麻烦,让 Claude 能直接访问动态网页内容。最适合需要实时数据的研究者或开发者,比如监控竞品价格或抓取新闻。但要注意,它依赖第三方 API,可能涉及隐私和成本问题。