elog-copilot-postgres
CommunityAutonomous SQL assistant for LCLS elog data.
System Documentation
What problem does it solve?
Autonomous SQL assistant for researchers analyzing LCLS experiment elog data in PostgreSQL with Row-Level Security. Executes queries via psql, answers database questions, and handles LCLS-specific concepts (run numbers, experiments, questionnaires, detectors, workflows, logbook entries). Results are automatically filtered by the user's experiment permissions via RLS. 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 PostgreSQL database via psql and returns structured results, honoring RLS restrictions.
- Answers questions about experiments, runs, detectors, questionnaires, logbook entries, and workflows using the schema described in references/schema.md.
- Guides on constructing queries and interpreting results for research planning and data discovery.
Quick Start
Query the elog database for a specific experiment’s runs and related logbook entries.
Dependency Matrix
Required Modules
None requiredComponents
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: elog-copilot-postgres Download link: https://github.com/carbonscott/deploy-opencode/archive/main.zip#elog-copilot-postgres Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.