Your Project History, Always Available
What did you say about this project last month? Notis logs every status update so retrospectives are rich, decisions are documented, and history is permanent.
Trigger
Project Update Posted
Fires when a project status update is posted on the Linear project's Updates tab. Covers projects in both public and private teams — polls with the connected user's token.
Action
Execute ClickHouse Query
Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.
Why this helps
Project status updates are posted to Linear's Updates tab, but they're scattered and hard to find later. Retrospectives lack context because you can't easily review what you said when.
- Complete archive of all project status updates for rich retrospectives
- Permanently documented project timeline and decision history
- Easy retrieval of what was said when for context and learning
Setup
Build it in a few focused steps.
- 1Connect Linear and ClickHouse to Notis.
- 2Tell Notis: 'When a project status update is posted, log it to my project updates archive with author, project, update text, and timestamp.'
- 3Notis sets the Project Update Posted trigger automatically.
- 4Choose your notification channel.
- 5Test by posting a project update and checking that it appears in your ClickHouse archive.
Questions about this workflow
Can I search project updates by keyword?
Yes. Use ClickHouse full-text search to find updates about blockers, risks, milestones, or anything you mention.
How is this useful for retrospectives?
Review all updates from a sprint or month. You see the actual narrative of how the project evolved, decisions made, and problems solved.
Can I track sentiment over time?
Yes. If you're curious whether project sentiment got more negative, ClickHouse can analyze update text patterns over time.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Linear to ClickHouse. A trigger fires from one place; an action lands in another.
Linear triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. essential for ai agents to understand the complete database structure in a single call.
Comment Received Trigger
Triggered when a comment is received.
Get Table Schema
Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. this is essential for ai agents to understand table structure before constructing queries.
Issue Created Trigger
Triggered when a new issue is created.
List ClickHouse Databases
List all databases in the clickhouse instance. useful for discovering available databases before querying tables.
Issue Updated Trigger
Triggered when an issue is updated. For example labels are changed, issue status is changed, etc.
List ClickHouse Tables
List tables in clickhouse databases. returns information about tables including their engine, size, and row count.
Private Team Comment Created
Fires when a new comment is posted on an issue in a private Linear team (polled with the connected user's token).
Private Team Issue Created
Fires when a new issue appears in a private Linear team (polled with the connected user's token).
Private Team Issue Properties Updated
Fires when properties on an issue change in a private Linear team (polled with the connected user's token).
Connect any two apps with Notis in the middle.
Linear and ClickHouse, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business ClickHouse.