skills.rest
instrument-org
instrument-orgOFFICIAL
Explore all skills by this author →
Website𝕏@tryinstrumentGitHub

task-database-query

Query task database files with read-only SQL statements.

3|Updated Apr 6, 2026
Search Tags:#SQL#data retrieval#database query#task analysis#record inspection
One-click install
npx skills add https://github.com/instrument-org/instrument --skill task-database-query
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: task-database-query
Source: https://github.com/instrument-org/instrument/tree/main/.agents/skills/task-database-query
Command: npx skills add https://github.com/instrument-org/instrument --skill task-database-query

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill enables safe, read-only SQL queries on task database files to retrieve stored records like messages, sessions, and parts, aiding in detailed task investigation.

Core Features & Use Cases

  • SQL-based Querying: Perform read-only SQL queries on task databases for in-depth analysis.
  • Task Record Retrieval: Access key-value pairs from sessions, messages, and parts for detailed insights.
  • Use Case: Imagine you need to analyze task history for a complex multi-step task. This Skill allows you to write a SQL query to extract and display the relevant sessions and messages.

Quick Start

Run a SQL query to extract and display the latest 20 sessions from a task database.

Frequently Asked Questions about task-database-query

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

FAQPage Schema
How do I query task database files with SQL to retrieve session and message records?▼

You can query task database files by running read-only SQL statements like SELECT and WITH to retrieve stored sessions, messages, and parts for detailed task investigation.

What SQL statements are supported for read-only database query in an AI workspace?▼

Read-only database query supports SELECT, WITH, EXPLAIN, and PRAGMA statements, ensuring safe data retrieval without modifying the underlying task database records.

Can I use SQLite json functions for data extraction during task analysis?▼

Yes, SQLite operations and json functions are required for data extraction, allowing you to parse and access key-value pairs from sessions and parts during task analysis.

What is the best way to inspect task history records for a complex multi-step task?▼

The best way to inspect task history is to execute targeted SQL queries against the task database to extract and display relevant sessions and messages for multi-step analysis.

Are write operations allowed when querying task database files for record inspection?▼

No, write operations are not allowed; record inspection is strictly limited to read-only SQL queries to ensure the integrity of the task database files.

Related Skills

Explore More Software Engineering Skills→
QuintenpsQuintenps

session-recovery

Query the session_store SQLite database to resume interrupted Copilot CLI sessions.

Community
Intermediate
groeimetaigroeimetai
77

import-export

Manage ServiceNow data migration with import sets, transform maps, and exports.

Community
Advanced
coco-researchcoco-research
264

brain:update

Scan conversations and write new decisions, tasks, entities, and events to a project brain database.

Community
Advanced
RepairYourTechRepairYourTech
6

drizzle-orm

Define TypeScript schemas and build type-safe SQL queries with Drizzle ORM.

Community
Advanced