searching-message-history

Query the local SQLite database for past Telegram messages and links.

20|11|Updated Sep 8, 2020
One-click install
npx skills add https://github.com/tomcounsell/ai --skill searching-message-history
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: searching-message-history
Source: https://github.com/tomcounsell/ai/tree/main/.claude/skills/searching-message-history
Command: npx skills add https://github.com/tomcounsell/ai --skill searching-message-history

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps users locate and reconstruct information from Telegram conversations by querying a local history database and stored links, saving time when trying to verify past statements or find references.

Core Features & Use Cases

  • Local history search: Query messages and links from the SQLite database at ~/.valor/telegram_history.db to surface relevant conversations.
  • Cross-chat context: Retrieve content across multiple chats or focus on a single chat, date range, or keyword.
  • Link extraction and verification: Find shared URLs and their metadata to verify sources or track references.

Quick Start

Search for a keyword across recent chats in the Telegram history database.

Frequently Asked Questions about searching-message-history

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

FAQPage Schema
How do I search my Telegram chat history by keyword?

To search Telegram chat history, you can query the local SQLite database at ~/.valor/telegram_history.db. This allows you to retrieve past messages and reconstruct conversations by applying keyword searches across all chats or a specific chat.

Can I retrieve shared links from past Telegram conversations?

Yes, you can retrieve shared links from Telegram conversations by querying the links table in the local history database. This allows you to find shared URLs and their metadata to verify sources or track references.

How do I filter Telegram messages by date range using SQLite?

You can filter Telegram messages by date range by running structured SQL queries against the messages table in the telegram_history database. This allows you to locate specific conversations and reconstruct discussions within a specific timeframe.

What database format is used for storing Telegram message history?

Telegram message history is stored in a local SQLite database located at ~/.valor/telegram_history.db. This database contains messages and links tables that support structured SQL queries to surface relevant chat content.

Does searching Telegram history require a specific local database setup?

Yes, searching Telegram history requires a local SQLite database at ~/.valor/telegram_history.db. You must have this database populated with your chat messages and links before you can run keyword searches or retrieve past conversations.

Are there limitations to searching Telegram history across multiple chats?

A limitation of searching Telegram history is that it relies entirely on the data within the local telegram_history.db database. You can retrieve cross-chat context, but only if the messages and links were previously stored in this local SQLite database.