Review GitHub pull requests with AI and log results to PostgreSQL and Slack

by Oneclick AI Squad ✓ · 156 views · created 2026-02-24 · Engineering, AI Summarization

What this workflow does

This workflow has 10 nodes and runs on Github events (pull request). Along the way it connects GitHub and Postgres.

How it runs

Trigger: On Github events (pull request).

1. Fetch Changed Files in PR (HTTP Request): calls an HTTP API
2. Merge: merges the data from its input branches
3. Extract Code Diffs (Code): runs custom JavaScript code
4. Score Review & Categorize Issues (Code): runs custom JavaScript code
5. Route by Review Severity (Switch): routes items into 2 branches
6. Post Review to GitHub PR (HTTP Request): calls an HTTP API (POST)
7. Store Review Results in PostgreSQL (Postgres): uses Postgres
8. Send Summary to Slack (HTTP Request): calls an HTTP API (POST)
9. Log Review Completion (Code): runs custom JavaScript code

Services it uses

GitHubPostgres

Before you upgrade to n8n 3.0

Nodes used (6)

• Github Triggern8n-nodes-base.githubTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Switchn8n-nodes-base.switch
• Postgresn8n-nodes-base.postgres

From the author

Automatically detects new GitHub Pull Requests, analyzes changed code with AI, generates detailed review comments (quality, security, performance, best practices), posts suggestions back to the PR, stores results in a database, and sends notifications. Good…

View the original on n8n.io → Check your own copy