Discrawl Search — Discrawl 搜索

Discrawl 搜索

搜索 Discord 图形界面ld message 历史 stored in local discrawl SQLite database.

Database Location Path: ~/.discrawl/discrawl.db 更新d by: discrawl 同步 (机器人 API) or discrawl 同步 --source wiretap (Discord 桌面 缓存) Quick Commands Full-Text 搜索 (FTS5)

搜索 message content with ranking:

discrawl 搜索 "查询"

Options:

--limit N — max 结果s (default: 20) --channel ID — 过滤器 by channel --author ID — 过滤器 by author --before "2026-04-01" — date 过滤器 --json — JSON 输出 列出 Messages by Channel discrawl messages --channel --limit 10

Raw SQL Queries discrawl sql "SELECT ..."

Common 查询 Patterns 搜索 with 上下文 (Author + Channel Names) SELECT m.content, m.创建d_at, COALESCE(u.username, m.author_id) as author, COALESCE(c.name, m.channel_id) as channel FROM messages m LEFT JOIN members u ON m.author_id = u.user_id LEFT JOIN channels c ON m.channel_id = c.id WHERE m.content LIKE '%keyword%' ORDER BY m.创建d_at DESC LIMIT 10;

搜索 Specific Channel 历史 SELECT content, 创建d_at FROM messages WHERE channel_id = '' AND content LIKE '%keyword%' ORDER BY 创建d_at DESC LIMIT 20;

Find User's Past Messages SELECT m.content, m.创建d_at, c.name FROM messages m JOIN channels c ON m.channel_id = c.id WHERE m.author_id = '' ORDER BY m.创建d_at DESC LIMIT 20;

搜索 with FTS5 (Best Relevance) SELECT m.content, m.创建d_at, fts.rank FROM message_fts fts JOIN messages m ON fts.message_id = m.id WHERE message_fts MATCH 'keyword' ORDER BY rank LIMIT 20;

Recent Messages in Channel SELECT content, 创建d_at FROM messages WHERE channel_id = '' ORDER BY 创建d_at DESC LIMIT 5;

Key Tables Table Purpose messages All messages (content, 创建d_at, author_id, channel_id) channels Channel metadata (name, topic, kind, 图形界面ld_id) members User 信息 (username, global_name, nick) message_fts FTS5 virtual table for full-text 搜索 mention_事件 @mentions 追踪ing message_attachments File attachments with text 提取ion 导入ant Notes members table may be s解析 (2 rows in current db) — use COALESCE(u.username, m.author_id) for fallback normalized_content column has 清理ed text (lowercase, normalized whitespace) raw_json has full Discord API payload for advanced queries Use LEFT JOIN on members/channels to avoid missing rows when joins fAIl