Manage Supabase database records with Telegram bot commands Workflow Solution

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building. Improves internal consulting operations and productivity.

Manage Supabase database with Telegram commands How it works Receive message — Telegram trigger captures incoming bot messages Validate user — Checks if sender's chat ID is in the authorized list Parse command — Extracts command type (/add, /list, etc.) and parameters Route & execute — Performs the appropriate Supabase operation (INSERT, SELECT, UPDATE, DELETE) Respond — Sends formatted results back to Telegram Turn your Telegram into a powerful database management interface. This workflow lets you create, read, update, delete, and search records in your Supabase database using simple chat commands — no SQL knowledge required. Who is this for? Small business owners, freelancers, and teams who need to manage data on the go without opening dashboards or writing queries. Perfect for inventory tracking, simple CRM, expense logging, or any scenario where you need quick mobile access to your database. What problem does it solve? Managing database records typically requires logging into admin panels or writing SQL queries. This workflow eliminates that friction by letting you interact with your data through familiar Telegram messages, from anywhere, on any device. Benefits Mobile database access** — Manage your data from anywhere using just your phone Zero SQL required** — Simple commands replace complex database queries Secure by default** — Only authorized Telegram users can access your data Instant feedback** — Get formatted responses confirming every operation Fully customizable** — Adapt to any table structure with minimal changes Available commands | Command | Format | Example | |---------|--------|---------| | /add | name, price, quantity, category | /add iPhone 15, 999.99, 50, electronics | | /list | [category] | /list or /list electronics | | /get | id | /get 15 | | /update | id field=value | /update 15 price=899 quantity=45 | | /delete | id | /delete 15 | | /search | text | /search iPhone | | /help | — | Shows all available commands | Set up steps 1. Create your Telegram bot Message @BotFather on Telegram Send /newbot and follow the prompts Save the API token you receive 2. Get your Telegram chat ID Message @userinfobot on Telegram It will reply with your chat ID number 3. Create the Supabase table Run this SQL in your Supabase project's SQL Editor: CREATE TABLE products ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, price DECIMAL(10,2), quantity INTEGER DEFAULT 0, category TEXT, created_at TIMESTAMP DEFAULT NOW() ); 4. Configure the workflow Import the workflow into AlekSystem Add your Telegram Bot credentials (using the API token from step 1) Add your Supabase credentials (Project URL + API Key from Supabase dashboard) Open the "Is Authorized?" node and replace 123456789 with your actual chat ID from step 2 Activate the workflow 5. Test it Send /help to your bot to verify everything works! Customization Adding more authorized users Open the "Is Authorized?" node Click "Add condition" Add another OR condition: chatId equals [new user's chat ID] Using a different table Change products to your table name in all Supabase nodes Update the field parsing in the "Parse Command and Parameters" code node Update field mappings in "Supabase Insert Product" and "Prepare Update Data" nodes Adjust the help message in "Send Help Message" node Adding more fields Modify the command parsing logic in "Parse Command and Parameters" Add field mappings in the Supabase Insert node Update the "Prepare Update Data" Set node with new fields Update the help message Example use cases Inventory management** — Track stock levels from your phone while in the warehouse Simple CRM** — Add and lookup contacts on the go Expense tracking** — Log expenses as they happen Task management** — Create and update tasks without opening any app Field data collection** — Teams can submit data from anywhere Requirements AlekSystem instance (cloud or self-hosted) Telegram account Supabase account (free tier works) Difficulty level: Intermediate Estimated setup time: 15-20 minutes Monthly operating cost: $0 (Telegram and Supabase free tiers)

Best fit

Need another direction?