skills.rest
mcarcaso
mcarcasoCOMMUNITY
Explore all skills by this author →
GitHub

keyword-history-search

Retrieves exact chat messages from a database via SQL queries with structured metadata.

Updated Feb 13, 2026
Search Tags:#database#audit#search#sql#history#conversations#messages
One-click install
npx skills add https://github.com/mcarcaso/pHouseVito --skill keyword-history-search
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: keyword-history-search
Source: https://github.com/mcarcaso/pHouseVito/tree/main/src/skills/builtin/history
Command: npx skills add https://github.com/mcarcaso/pHouseVito --skill keyword-history-search

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Retrieve exact messages from the conversation database using SQL queries to enable precise audits, debugging, and verification of past interactions.

Core Features & Use Cases

  • Exact message retrieval: Fetch messages by timestamp, session_id, channel, or content with precise results.
  • Structured outputs: Return readable fields like time, session_id, channel, role, and content previews for analysis.
  • Use Case: Quickly locate specific conversations or verify what was said in a given session to support compliance or debugging.

Quick Start

Run a SQL query against the user/vito.db to fetch messages matching a keyword within a time window and export the results.

Frequently Asked Questions about keyword-history-search

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

FAQPage Schema
How do I search chat message history using SQL?▼

You can search chat message history using SQL by executing queries against the conversation database to retrieve exact messages. This allows you to fetch specific transcripts by timestamp, session_id, channel, or content for precise audits.

What is the best way to audit past conversations by keyword and date range?▼

Auditing past conversations by keyword and date range is done by running SQL queries against the conversation database. The system retrieves exact matching messages and outputs structured fields like timestamps, session IDs, channels, and content previews.

Can I retrieve session-specific transcripts from the conversation database?▼

Yes, you can retrieve session-specific transcripts from the conversation database. By querying with SQL using the session_id, you fetch exact messages and receive structured outputs containing the timestamp, channel, role, and content preview.

Does keyword history search safeguard sensitive data during message retrieval?▼

Yes, the keyword history search process safeguards sensitive data while retrieving exact messages from the conversation database. It returns structured outputs with timestamps, session IDs, channels, and content previews without exposing vulnerable information.

What fields are included in the structured output when I query chat history?▼

When you query chat history, the structured output includes timestamps, session IDs, channels, roles, and content previews. These fields are returned by executing SQL queries against the conversation database for precise message retrieval.

Related Skills

Explore More Data & Analytics Skills→
AstorYHAstorYH
15

postgresql-query-runner

Execute PostgreSQL SQL queries against specified database connections.

Community
Intermediate
AtemndobsAtemndobs

csv-export

Export RFP, evaluation, and pursuit data to CSV files.

Community
Intermediate
abdulahad139abdulahad139

configure-chatkit

Configure OpenAI ChatKit in Next.js projects with Better Auth.

Community
Intermediate
paulchiupaulchiu
3

search-shadow-transcripts

Search Shadow.app transcripts in a local SQLite database by keywords and date ranges.

Community
Intermediate