Hypertouch

Run Query

Execute a read-only ClickHouse SQL query. Returns JSON results. Only SELECT/SHOW/DESCRIBE/EXPLAIN allowed.

List Tables

List all tables in the ClickHouse database.

Describe Table

Show the schema (columns, types, defaults) of a ClickHouse table.

Table Row Counts

Get row counts for all tables in the ClickHouse database.

Mysql Query

Execute a read-only MySQL query against the Laravel database (nate_HT_LI). Only SELECT/SHOW/DESCRIBE/EXPLAIN allowed.

Mysql Tables

List all tables in the Laravel MySQL database (nate_HT_LI).

Mysql Describe

Show the schema (columns, types, nullable, key, default, extra) of a MySQL table in the Laravel database.

Read File

Read the contents of a file from the HyperTouch Laravel project. Path is relative to the project root.

List Directory

List files and directories in the HyperTouch Laravel project. Path is relative to project root.

Search Files

Search for text in the HyperTouch Laravel project files using grep. Excludes vendor/, node_modules/, .git/, and storage/logs/.

Read Log

Read the last N lines of the Laravel application log (storage/logs/laravel.log).

Dev Task Create

Create a dev task in the "ideas" column.

Dev Task Add Note

Add a note to an existing dev task.

Dev Task Add Tag

Add a tag to an existing dev task by tag name.

Dev Task Move

Move a dev task to a different stage/column on the board.

Dev Project List

List all dashboard projects with status, progress, phase counts, created_at, and recent update timestamps. Call this FIRST before creating or updating, to discover existing slugs and to get the timestamp history needed to judge velocity.

Dev Project Create

Create a dashboard project. You generate every field: tooltip (~10 words), the three detail blurbs, and the first 100 word summary. progress_pct is 0-100. For backfilling existing work, pass started_at (YYYY-MM-DD) so the velocity clock reflects when the work actually began, not today.

Dev Project Update

Push a progress update. Appends a 100 word summary to the changelog and updates the live row. Pass only what changed; copy fields are optional. eta_date is recomputed from the start clock and phase counts automatically, unless you pass eta_text as an override.