smartsheet

Query the LCLS Smartsheet closeout database for experiment details and notes.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a structured method to query and retrieve information from the LCLS Smartsheet closeout database, enabling fast access to experiment details, technical issues, safety notes, and engineering concerns from past experiments.

Core Features & Use Cases

  • Read-only access to the SQLite database located at /sdf/group/lcls/ds/dm/apps/dev/data/smartsheet/closeout_notes.db
  • Query construction and execution using sqlite3 with header and column-formatted output
  • Guidance on interpreting the schema via references/schema.md, and practical search patterns for topics, comments, and actions
  • Use cases include locating experiments by instrument or spokesperson, inspecting technical or safety notes, and extracting actionable items

Quick Start

Query the closeout_notes.db to fetch the latest Smartsheet closeout records for a given instrument.

Frequently Asked Questions about smartsheet

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

FAQPage Schema
How do I query past LCLS experiment closeout notes for technical issues and safety concerns?

Query the LCLS Smartsheet closeout database to retrieve experiment details, technical issues, safety notes, and engineering concerns by running read-only sqlite3 queries against the closeout_notes.db file.

Can I search the Smartsheet closeout database by spokesperson or instrument?

Yes, you can search the closeout database by spokesperson or instrument. The Skill uses the schema.md reference file to interpret tables and columns, guiding you to construct and execute targeted sqlite3 queries for matching records.

How do I set up and run SQL queries against the closeout_notes.db SQLite database?

To run SQL queries against the closeout_notes.db SQLite database, set the SS_DB environment variable, use sqlite3 with header and column formatting, and reference the schema.md file to identify the correct tables and columns for your search.

What kind of data is stored in the LCLS Smartsheet experiment closeout database?

The LCLS Smartsheet experiment closeout database stores details from past experiments, including technical issues, safety notes, engineering concerns, and actionable items extracted from historical Smartsheet closeout records.

Does the Smartsheet closeout query helper support write access to modify experiment records?

No, the Smartsheet closeout query helper supports read-only SQLite access to the database. It is designed strictly for retrieving and inspecting historical experiment data, not for modifying or adding new closeout records.

What is the best way to extract actionable items from past LCLS experiment closeout notes?

The best way to extract actionable items is to query the closeout_notes.db using sqlite3, applying practical search patterns for topics, comments, and actions guided by the schema references to format and filter the results.