ComfyUI-Supabase-Power

A powerful node package for Supabase integration in ComfyUI. Provides 26 nodes covering Database, Storage, Realtime, Auth, and Edge Functions.

Features

• Modern API: Uses the latest ComfyExtension API (2025+)
• Full Supabase Coverage: Database CRUD, Storage, Realtime subscriptions, Auth, Edge Functions
• Chainable Builders: FilterBuilder, OrderBy, JSONBuilder for composable queries
• Type Safety: Custom types (SUPABASE_CLIENT, FILTER_CHAIN, etc.)
• Error Handling: Built-in error handling with RLS-aware messages

Installation

cd ComfyUI/custom_nodes
git clone https://github.com/your-repo/comfyui-supabase-power
cd comfyui-supabase-power
pip install -r requirements.txt

Nodes Overview

Config (1 node)

| Node | Description | |------|-------------| | SupabaseConnection | Create a Supabase client connection |

Database (6 nodes)

| Node | Description | |------|-------------| | SupabaseSelect | Query data with filters, ordering, pagination | | SupabaseInsert | Insert new records | | SupabaseUpdate | Update existing records (requires filters) | | SupabaseDelete | Delete records (requires filters) | | SupabaseUpsert | Insert or update on conflict | | SupabaseRPC | Call PostgreSQL functions |

Query Builder (3 nodes)

| Node | Description | |------|-------------| | FilterBuilder | Chainable WHERE conditions (eq, neq, like, in, etc.) | | OrderBy | Chainable ORDER BY | | Pagination | LIMIT/OFFSET or range-based pagination |

Storage (5 nodes)

| Node | Description | |------|-------------| | SupabaseUpload | Upload IMAGE/AUDIO/BYTES with optional DB update | | SupabaseDownload | Download files as IMAGE/AUDIO/BYTES/STRING | | SupabaseListFiles | List files in a bucket | | SupabaseDeleteFile | Delete files from storage | | SupabaseSignedURL | Create temporary access URLs |

Realtime (2 nodes)

| Node | Description | |------|-------------| | SupabaseSubscribe | Subscribe to database changes | | SupabaseBroadcast | Send broadcast messages |

Auth (2 nodes)

| Node | Description | |------|-------------| | SupabaseSignIn | Email/password authentication | | SupabaseUserInfo | Get current user information |

Edge Functions (1 node)

| Node | Description | |------|-------------| | SupabaseEdgeFunction | Invoke Edge Functions |

Utils (3 nodes)

| Node | Description | |------|-------------| | JSONBuilder | Chainable JSON object construction | | ResponseParser | Extract values from JSON with dot notation | | ErrorHandler | Handle errors with fallbacks |

Usage Examples

Basic Select with Filters

[SupabaseConnection]
    → [FilterBuilder: column="status", op="eq", value="active"]
    → [FilterBuilder: column="price", op="gt", value="100"]
    → [SupabaseSelect: table="products", columns="id,name,price"]
    → [ResponseParser: path="0.name"]

Upload Image and Update Database

[Image Generation]
    → [SupabaseUpload:
         bucket="images",
         update_table="generations",
         update_column="output_url",
         update_id_column="id",
         update_id_value="123"]
    → [SupabaseBroadcast:
         channel_name="notifications",
         event="image_ready"]

Search by Name (ilike)

[SupabaseConnection]
    → [FilterBuilder: column="name", op="ilike", value="%chair%"]
    → [SupabaseSelect: table="assets", columns="id,name,usd_path"]
    → [ResponseParser: path="0.usd_path"]

Custom Types

• SUPABASE_CLIENT - Supabase client wrapper
• FILTER_CHAIN - List of filter conditions
• ORDER_CONFIG - Ordering configuration
• PAGINATION_CONFIG - Pagination settings
• REALTIME_CHANNEL - Realtime channel wrapper
• JSON - Generic JSON data
• LIST - Generic list

Security Notes

1. Use service_role key carefully - It bypasses RLS
2. Prefer anon key for client-facing workflows
3. UPDATE/DELETE require filters - Safety mechanism to prevent accidental mass changes
4. Credentials in nodes - Consider using environment variables in production

Requirements

• ComfyUI with modern API support (2025+)
• Python 3.10+
• supabase>=2.0.0
• httpx>=0.25.0
• websockets>=12.0
• Pillow>=10.0.0
• numpy>=1.24.0

Пакет comfyui-supabase-power полностью создан. Вот итоговая структура:

Созданный пакет: ComfyUI-Supabase-Power

Структура (40 файлов):

comfyui-supabase-power/ ├── init.py # Async entrypoint (ComfyExtension) ├── pyproject.toml # Package config ├── requirements.txt # Dependencies ├── README.md # Documentation │ ├── core/ │ ├── init.py │ ├── client.py # SupabaseClientManager │ ├── types.py # Custom types (SUPABASE_CLIENT, etc.) │ └── utils.py # Image conversion, query builders │ ├── nodes/ │ ├── init.py # ALL_NODES export │ ├── config/ │ │ └── connection.py # SupabaseConnection │ ├── database/ │ │ ├── select.py, insert.py, update.py │ │ ├── delete.py, upsert.py, rpc.py │ ├── query/ │ │ ├── filter.py # FilterBuilder (chainable) │ │ ├── order.py # OrderBy (chainable) │ │ └── pagination.py # Pagination │ ├── storage/ │ │ ├── upload.py # Upload with DB update │ │ ├── download.py, list_files.py │ │ ├── delete_file.py, signed_url.py │ ├── realtime/ │ │ ├── subscribe.py # SupabaseSubscribe │ │ └── broadcast.py # SupabaseBroadcast │ ├── auth/ │ │ ├── sign_in.py, user_info.py │ ├── edge/ │ │ └── invoke.py # SupabaseEdgeFunction │ └── utils/ │ ├── json_builder.py # JSONBuilder (chainable) │ ├── response_parser.py # Path-based JSON extraction │ └── error_handler.py # Error handling with fallbacks │ └── web/js/ └── supabase_nodes.js # Frontend enhancements

26 узлов:

• Config: SupabaseConnection
• Database (6): Select, Insert, Update, Delete, Upsert, RPC
• Query Builder (3): FilterBuilder, OrderBy, Pagination
• Storage (5): Upload, Download, ListFiles, DeleteFile, SignedURL
• Realtime (2): Subscribe, Broadcast
• Auth (2): SignIn, UserInfo
• Edge (1): EdgeFunction
• Utils (3): JSONBuilder, ResponseParser, ErrorHandler

Особенности:

• Современный ComfyExtension API (comfy_api.latest)
• Chainable паттерн для фильтров, сортировки, JSON
• Upload с автоматическим обновлением БД
• Защита от случайного DELETE/UPDATE без фильтров
• RLS-aware сообщения об ошибках

& "E:\WORK\ComfyUI_windows_portable\python_embeded\python.exe" -m pip install -r "E:\WORK\ComfyUI_windows_portable\ComfyUI\custom_nodes\СomfyUI-Supabase-Power\requirements.txt"

License

MIT License