elog-copilot

Execute SQL queries against the elog SQLite database to answer LCLS experiment questions.

Updated Jan 27, 2026
One-click install
npx skills add https://github.com/carbonscott/deploy-opencode --skill elog-copilot
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: elog-copilot
Source: https://github.com/carbonscott/deploy-opencode/tree/main/claude/skills/elog-copilot
Command: npx skills add https://github.com/carbonscott/deploy-opencode --skill elog-copilot

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Autonomous SQL assistant for researchers analyzing LCLS elog data. Executes queries via sqlite3, answers database questions, and handles LCLS-specific concepts (run numbers, experiments, questionnaires, detectors, workflows, logbook entries). Use when users ask about LCLS experiments, run data, detector configurations, sample information, logbook entries, analysis workflows, or any question answerable from the elog database.

Core Features & Use Cases

  • Executes SQL queries against the elog SQLite database to retrieve run metadata, logbook entries, detector configurations, and workflow details.
  • Interprets results within the context of LCLS experiments, supporting run-number logic, questionnaire fields, and elog content.
  • Use Case: Quickly answer questions about a specific experiment’s logbook entries and detector settings to support data quality assessments.

Quick Start

Query the ELOG SQLite database for all logbook entries for a given experiment.

Frequently Asked Questions about elog-copilot

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

FAQPage Schema
How do I query SQLite logbook entries for LCLS experiments?

You can query LCLS logbook entries by executing SQL against the elog-copilot SQLite database to retrieve run metadata, detector configurations, and workflow details. The assistant interprets results within the context of LCLS experiment workflows.

What kind of experiment data can I retrieve from an elog SQLite database?

From an elog SQLite database you can retrieve run histories, logbook entries, detector configurations, sample information, and workflow details. It specifically supports LCLS concepts like run numbers, experiments, and questionnaires.

Do I need to know the database schema to run SQL queries on elog data?

Yes, schema awareness is required to construct accurate SQL queries on elog data. You need the elog-copilot database path and SQLite access to autonomously execute queries and retrieve experiment metadata.

Can I use SQL to find detector configurations for specific LCLS run numbers?

Yes, you can use SQL to find detector configurations for specific LCLS run numbers by querying the elog SQLite database. The assistant applies run-number logic to retrieve accurate detector settings and logbook details.

What is the best way to analyze experiment metadata from a local SQLite file?

The best way to analyze experiment metadata from a local SQLite file is using an autonomous SQL assistant that executes queries to answer questions about logbook entries and workflows. This supports quick retrieval for data quality assessments.

Why does my SQL query fail to retrieve logbook entries from the elog database?

SQL queries retrieving logbook entries from the elog database may fail due to incorrect schema awareness or an invalid database path. Accurate SQLite access and schema knowledge are required to construct functional queries for experiment metadata.