cyberneticlibrary

Format messages for Slack channels

slack-formattingskillsetup L129,740
nanocoai/nanoclaw
What it does

Parse and transform data via SQL queries with joins/aggregations

Best for

Extracting and reshaping structured data when declarative SQL is clearer than imperative transformation code.

Inputs
  • · SQL query string
  • · input table or dataset
Outputs
  • · query result rows
  • · aggregations
  • · joined output
Requires
  • · SQL database (PostgreSQL/SQLite/DuckDB)
Preconditions
  • · valid SQL syntax
  • · tables exist
  • · column names match query
Failure modes
  • · syntax error in query
  • · missing columns in join
  • · type mismatch in WHERE clause
Trust signals
  • · standard SQL dialects
  • · aggregate and window functions
  • · multi-table joins
  • · ORDER/LIMIT support