sql_analysis

Name: sql_analysis
Availability: InStock
Author: dascard

Execute read-only SQL queries against SQLite chat log databases.

2|Updated Apr 6, 2026

Search Tags:#analytics #database #sqlite #sql #chat logs #data mining

Ready to run

npx skills add https://github.com/dascard/nanobot --skill sql-analysis-dascard

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql_analysis
Source: https://github.com/dascard/nanobot/tree/main/creatures/nanobot/prompts/skills/sql_analysis
Command: npx skills add https://github.com/dascard/nanobot --skill sql-analysis-dascard

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a secure, read-only interface to explore historical chat logs and user data, enabling data-driven insights into communication patterns without manual log searching.

Core Features & Use Cases

Historical Data Analysis: Perform complex queries to identify user activity trends, message frequency, or specific historical interactions.
Database Auditing: Inspect table structures and system state to understand the macro-level operation of the Nanobot environment.
Use Case: A user asks for their most active time of day or a summary of their past interactions; the Skill executes a targeted SQL query to retrieve and summarize this information from the chat_logs database.

Quick Start

Use the sql_analysis skill to select the last 10 messages from the chat_logs table where the session_id matches the current group.

Frequently Asked Questions about sql_analysis

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

FAQPage Schema

How do I query chat logs with SQL to analyze user activity?▼

Query chat logs with SQL by executing read-only SQLite queries to retrieve historical conversation data and identify user behavioral patterns. You can track activity trends, message frequency, and specific interactions without manual log searching.

Can I analyze message frequency in SQLite chat log databases?▼

Analyze message frequency in SQLite chat log databases by running targeted SQL queries to retrieve and summarize historical interactions. This process identifies user activity trends and retrieves specific messages based on session identifiers.

What is the best way to inspect table structures in a SQLite database?▼

Inspect SQLite table structures by executing read-only SQL queries to audit the database and understand the macro-level system state. This method reveals the schema of tables like chat_logs to guide further data retrieval.

Does SQL analysis support modifying data in the chat_logs database?▼

SQL analysis does not support modifying chat_logs databases because it implements strict read-only validation and query limits. This ensures database integrity and prevents unauthorized data modification during historical data retrieval.

How do I retrieve the last 10 messages from a specific chat session?▼

Retrieve the last 10 messages from a specific chat session by executing a read-only SQL query against the chat_logs table where the session_id matches the current group, ensuring secure historical data extraction.