telegram-archivelisted
Install: claude install-skill stanleytejakusuma/telegram-archive
# telegram-archive
Read-only access to an archived Telegram corpus captured by a separate
ingestion process into TimescaleDB.
The database isn't assumed reachable directly from the client machine;
this tool ships every query over `ssh <host> docker exec ... psql`. It
only ever issues `SELECT`s.
**This skill is the read/query half only.** Getting messages *into* the
database — a Telegram client login, a session, and a sync loop — is a
separate component you build yourself. See the repo's README for what
that involves and, importantly, the credential-handling cautions around
it (a session that can read your Telegram account is real-account-access
material, not a low-stakes API key).
## When to use
Invoke whenever the user wants to read or search archived Telegram content:
- "What did \<channel> post today / last hour?"
- "Search the archive for \<keyword>" / "any messages mentioning X?"
- "What channels are we archiving? Are any stale?"
- "Show me the links \<channel> shared today"
- "What's the context around message \<id>?"
- "How active has \<channel> been this week?"
## How to run
```bash
python3 /path/to/tg-archive <subcommand> [args] --host <your-host>
```
(The script is executable; run directly once you've installed it — see
the repo README for the multi-harness skill-install steps. Run
`... <subcommand> --help` for full per-command options.)
Configuration (host, container, db user/name, schema, optional aliases
file) is via flags or `TG_ARCHIVE_*` environment v