Connect Claude Code to PostgreSQL and Telegram

Execute a SELECT query and return results as JSON

Execute an INSERT, UPDATE, DELETE, or other non-SELECT statement

Execute a statement with multiple parameter sets (batch operations)

Execute query with cursor for large result sets

Bulk import data to a table using COPY

Bulk export data from a table using COPY

List all tables in a schema

Get column metadata for a table

Get detailed information about a table including constraints and indexes

Create a new table

Drop a table

Truncate a table (remove all rows)

List all schemas in the database

Create a new schema

Drop a schema

List all databases in the PostgreSQL server

List all indexes in a schema

Create an index on a table

Drop an index

List all views in a schema

Create a view

Drop a view

List all sequences in a schema

Get the next value from a sequence (nextval)

Get the current value from a sequence (currval)

Set the current value of a sequence (setval)

List all functions in a schema

Call a PostgreSQL function

List all constraints for a table

List all triggers in a schema

List all installed extensions

Create/install an extension

List all database users

List all database roles

Explain a query's execution plan

Vacuum a table to reclaim storage and update statistics

Analyze a table to update statistics

Begin a new transaction

Commit the current transaction

Rollback the current transaction

Send message directly to a chat ID

Send message to a public channel or group

Send a document/file to a chat ID

Deliver via webhook (no message required)

Send a photo to a chat

Send a video to a chat

Send an audio file to a chat

Send a voice note (.ogg) to a chat

Send a GIF or silent H.264/MPEG-4 AVC video

Send a circular video message

Send a sticker

Send a group of photos, videos, or documents as an album

Send a phone contact

Send a geographic location

Send a venue (location with title and address)

Send an animated emoji that displays a random value

Edit the text of a sent message

Edit the caption of a media message

Delete a message

Delete multiple messages at once

Pin a message in a chat

Unpin a message (or all messages) in a chat

Forward a message to another chat

Copy a message to another chat (without forward tag)

Show a 'typing…' or 'uploading…' indicator in a chat

Create and send a poll or quiz

Stop a running poll

Get full information about a chat

Get information about a member of a chat

Get the number of members in a chat

Get a list of administrators in a chat

Ban a user from a chat

Unban a previously banned user

Restrict a user's permissions in a chat

Promote a user to admin or update their admin rights

Change the title of a chat

Change the description of a chat

Create an additional invite link for a chat

Revoke an invite link to a chat

Answer a callback query from an inline keyboard button

Answer an inline query with a list of results

Set a reaction on a message

Get basic information about the bot

Get info about a file by its file_id (includes download URL)

Send a payment invoice

Confirm or reject a payment pre-checkout query

Guided channel setup flow. Registers a webhook with the bot, then generates a deep-link for the user. When the user adds the bot to their channel as admin, the channel ID is automatically detected and stored — no manual copy-pasting needed.

Connect a Telegram channel by entering its @username or numeric ID. The bot must already be added as an admin to the channel before running. This node validates the connection and returns the channel details. Works correctly in setup flows — runs once and returns channel_id immediately.