From stackql-skills
Generate and insert StackQL query cells into an existing Jupyter notebook. Creates a markdown heading cell and a %%stackql query cell, with optional visualization. Works with the pystackql magic extension.
How this skill is triggered — by the user, by Claude, or both
Slash command
/stackql-skills:notebook-cellThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
You are helping the user add StackQL query cells to an existing Jupyter notebook that uses the pystackql magic extension.
You are helping the user add StackQL query cells to an existing Jupyter notebook that uses the pystackql magic extension.
Input: $@
Follow these steps in order.
Look for open or recently modified .ipynb files:
find . -name "*.ipynb" -not -path '*/.git/*' -not -path '*/.ipynb_checkpoints/*' 2>/dev/null
If multiple notebooks exist, check which ones already use pystackql:
grep -l "pystackql" *.ipynb 2>/dev/null
If there are multiple candidates, ask the user which notebook to add cells to.
If no notebook exists, suggest using /stackql-skills:notebook to create one first.
Read the notebook to understand:
pystackql.magic or pystackql.magics)$variable)Determine what the user wants:
--viz flag: what visualization to add (bar, line, table, or auto-detect)--no-display: suppress query output displayIf the input is natural language, use the existing notebook context (pulled providers, variables) to generate the appropriate query. If needed, discover the schema:
stackql exec "DESCRIBE <provider>.<service>.<resource>;" --output json
Follow these rules for all notebook cells:
---, ***, ___) or <hr/> tagsCreate 2-3 cells to insert:
## <Section Title>
<Brief description of what this query does.>
For single-line queries:
%stackql <QUERY>
For multi-line queries:
%%stackql
SELECT
<fields>
FROM <provider>.<service>.<resource>
WHERE <params>
Options:
--no-display to the %%stackql line if the flag was passed--csv-download if the user wants export capabilityUse $variable substitution for any values that match Python variables already defined in the notebook.
Use $$ to escape literal dollar signs in JSON path expressions.
Bar chart (--viz bar):
stackql_df.plot(kind='bar', x='<x_col>', y='<y_col>', title='<Title>');
Line chart (--viz line):
stackql_df.plot(kind='line', x='<x_col>', y='<y_col>', title='<Title>');
Table (--viz table):
stackql_df
Auto-detect: If the result likely has a categorical column and a numeric column, suggest a bar chart. If it has a date/time column and a numeric column, suggest a line chart. Otherwise, just display as a table.
Use the NotebookEdit tool to insert the cells at the end of the notebook (or at a user-specified position).
Briefly confirm what was added:
stackql_df will contain the query results as a pandas DataFramenpx claudepluginhub stackql/stackql-skills --plugin stackql-skillsProvides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Searches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.