Comprehensive n8n community node for Supabase with database and storage operations
npm install n8n-nodes-supabaseA comprehensive n8n community node for Supabase that provides both database and storage operations with enhanced functionality beyond the built-in Supabase node.
- Enhanced CRUD Operations: Create, Read, Update, Delete, and Upsert with advanced filtering
- Schema Management: Create/drop tables, add/remove columns, manage indexes
- Custom SQL Queries: Execute any SQL query directly
- Advanced Filtering: Support for complex filters and sorting
- Dual UI Modes: Simple form-based UI and advanced JSON mode
- File Management: Upload, download, list, delete, move, and copy files
- Multiple Upload Types: Binary data, URL downloads, or text content
- Bucket Management: Create, delete, and manage storage buckets
- Signed URLs: Generate time-limited access URLs
- File Metadata: Get detailed file information and manage metadata
- ✅ Complete storage operations support
- ✅ Schema management capabilities
- ✅ Advanced filtering and sorting
- ✅ Dual UI modes (simple + advanced)
- ✅ Smart Dropdowns: Auto-fetch project URLs and bucket names
- ✅ Project Caching: Recent project URLs cached for convenience
- ✅ Better error handling and validation
- ✅ Comprehensive file operations
- ✅ Bucket management
- ✅ Custom SQL query execution
1. Go to Settings > Community Nodes in your n8n instance
2. Click Install a community node
3. Enter: n8n-nodes-supabase
4. Click Install
``bash`In your n8n installation directory
npm install n8n-nodes-supabase
Add to your n8n Docker environment:
`bash`
docker run -it --rm \
--name n8n \
-p 5678:5678 \
-e N8N_COMMUNITY_PACKAGES="n8n-nodes-supabase" \
n8nio/n8n
1. Go to your Supabase Dashboard
2. Select your project
3. Go to Settings > API
4. Copy your Project URL and API Key
1. Create a new Supabase API credential
2. Project URL: Select from recent projects or enter manually (e.g., https://your-project.supabase.co)
3. Choose API Key Type:
- Anon Key: For client-side operations with RLS
- Service Role Key: For server-side operations (bypasses RLS)
4. Enter your API Key
Auto-Discovery Mode 🔍
- Management API Integration: Connect using your Supabase Management API token
- Organization Selection: Auto-discover and select from your organizations
- Project Auto-Discovery: Real-time project list with status and metadata
- Automatic URL Population: Project URLs auto-populated from selections
- Rich Metadata: See project status, region, creation date, and more
Manual Entry Mode ✏️
- Enhanced Validation: Better URL format validation and error messages
- Smart Caching: Recent project URLs cached for quick selection
- Improved Testing: Enhanced credential validation with detailed feedback
- Backward Compatibility: All existing configurations continue to work
Project & Organization Management
- Real Organizations: Load actual organizations from your Supabase account
- Live Project Data: See real project names, status, and regions
- Auto-Population: Project URLs automatically filled when selected
- Fallback Support: Graceful fallback to manual entry if API unavailable
Database Schema Discovery
- Table Auto-Discovery: Dropdown of actual tables from your database
- Column Intelligence: Auto-populate columns based on selected table
- Schema Awareness: Support for custom schemas beyond 'public'
- Metadata Rich: See table info like RLS status, size, and row counts
Storage Integration
- Bucket Auto-Fetch: Real-time bucket list with metadata
- Permission Validation: Automatic access permission checking
- Status Indicators: Visual indicators for public/private buckets
- Creation Metadata: See bucket creation dates and properties
- 🎯 Zero Configuration Errors: Eliminate typos in URLs, table names, and bucket names
- ⚡ Lightning Fast Setup: Auto-discovery reduces setup time by 90%
- 🔍 Real-Time Validation: Instant feedback on credential validity
- 📊 Rich Context: See project status, table schemas, and bucket properties
- 🔄 Always Current: Live data from your Supabase projects
- 🛡️ Enhanced Security: Management API integration with proper scoping
- 🔧 Flexible Configuration: Choose between auto-discovery or manual entry
- 🔄 Graceful Fallbacks: Manual entry available when auto-discovery fails
For Auto-Discovery mode, you'll need a Supabase Management API token:
1. Login to Supabase Dashboard: Go to https://supabase.com/dashboard
2. Account Settings: Click your profile/avatar in the top right
3. Access Tokens: Navigate to "Access Tokens" section
4. Generate Token: Click "Generate new token"
5. Set Permissions: Choose appropriate scopes:
- Projects: Read access to list and get project details
- Organizations: Read access to list organizations
- Database: Read access for schema information
- Storage: Read access for bucket management
6. Copy Token: Save the token securely (starts with sbp_)
Note: Management API tokens are different from project API keys and are used for managing multiple projects and organizations.
#### Create a Record
`javascript
// Simple Mode
Resource: Database
Operation: Create
Table: users
Columns:
- name: John Doe
- email: john@example.com
- age: 30
// Advanced Mode
Resource: Database
Operation: Create
Table: users
JSON Data: {
"name": "John Doe",
"email": "john@example.com",
"age": 30
}
`
#### Read with Filters
`javascript
// Simple Mode
Resource: Database
Operation: Read
Table: users
Filters:
- Column: age, Operator: Greater Than, Value: 25
- Column: status, Operator: Equals, Value: active
Return Fields: id,name,email
Limit: 10
// Advanced Mode
Resource: Database
Operation: Read
Table: users
Advanced Filters: {
"age": {"gt": 25},
"status": "active"
}
`
#### Create Table
`javascript`
Resource: Database
Operation: Create Table
Table Name: products
Column Definitions:
- Name: id, Type: uuid, Primary Key: true, Default: gen_random_uuid()
- Name: name, Type: varchar(255), Nullable: false
- Name: price, Type: decimal(10,2), Nullable: false
- Name: created_at, Type: timestamptz, Default: now()
#### Upload File
`javascript`
Resource: Storage
Operation: Upload File
Bucket: documents
File Name: report.pdf
Input Type: Binary Data
Binary Property Name: data
#### Download File
`javascript`
Resource: Storage
Operation: Download File
Bucket: documents
File Path: reports/monthly-report.pdf
Output Format: Binary Data
#### List Files
`javascript`
Resource: Storage
Operation: List Files
Bucket: images
Folder Path: avatars/
Limit: 50
Sort Column: created_at
Sort Order: desc
#### Create Bucket
`javascript`
Resource: Storage
Operation: Create Bucket
Bucket Name: user-uploads
Public Bucket: false
File Size Limit: 10485760 // 10MB
Allowed MIME Types: image/jpeg,image/png,image/gif
| Operation | Description | Parameters |
|-----------|-------------|------------|
| create | Insert new row | table, data (columns or JSON) |read
| | Select rows | table, filters, sort, limit, offset |update
| | Update existing rows | table, data, filters |delete
| | Delete rows | table, filters |upsert
| | Insert or update | table, data, onConflict |createTable
| | Create new table | tableName, columnDefinitions |dropTable
| | Drop table | tableName, cascade |addColumn
| | Add column | tableName, columnDefinition |dropColumn
| | Drop column | tableName, columnName |createIndex
| | Create index | tableName, indexDefinition |dropIndex
| | Drop index | indexName |customQuery
| | Execute SQL | customSql |
| Operation | Description | Parameters |
|-----------|-------------|------------|
| uploadFile | Upload file | bucket, fileName, inputType, data |downloadFile
| | Download file | bucket, filePath, outputFormat |listFiles
| | List files | bucket, folderPath, options |deleteFile
| | Delete files | bucket, filePaths |moveFile
| | Move file | bucket, fromPath, toPath |copyFile
| | Copy file | bucket, fromPath, toPath |createBucket
| | Create bucket | bucketName, options |deleteBucket
| | Delete bucket | bucketName |listBuckets
| | List buckets | - |getBucketDetails
| | Get bucket info | bucketName |getFileInfo
| | Get file info | bucket, filePath |generateSignedUrl
| | Create signed URL | bucket, filePath, expiresIn |
The node respects Supabase's Row Level Security policies:
- Anon Key: Operates within RLS policies
- Service Role Key: Bypasses RLS (use with caution)
Comprehensive error handling with detailed messages:
`javascript`
// Automatic retry on network errors
// Validation of table/column names
// Clear error messages for debugging
// Support for n8n's "Continue on Fail" option
- Connection pooling
- Efficient query building
- Batch operations support
- Proper indexing recommendations
#### 1. "Invalid credentials" Error
- Verify your Project URL format: https://your-project.supabase.co
- Check API key type matches your use case
- Ensure API key has required permissions
#### 2. "Table not found" Error
- Verify table name spelling and case
- Check if table exists in correct schema
- Ensure API key has access to the table
#### 3. Storage Upload Fails
- Verify bucket exists and is accessible
- Check file size limits
- Ensure proper MIME type configuration
- Verify RLS policies for storage
#### 4. RLS Policy Errors
- Use Service Role key to bypass RLS for testing
- Check your RLS policies in Supabase dashboard
- Ensure authenticated user has proper permissions
Enable detailed logging in n8n settings to see:
- Full SQL queries generated
- Supabase API responses
- Error stack traces
- Performance metrics
We welcome contributions! Please see our Contributing Guide for details.
`bashClone the repository
git clone https://github.com/sudsarkar13/n8n-nodes-supabase.git
cd n8n-nodes-supabase
$3
bash
Run unit tests
npm run testRun integration tests (requires Supabase project)
SUPABASE_URL=your-url SUPABASE_KEY=your-key npm run test:integrationRun with coverage
npm run test:cov
``See CHANGELOG.md for version history and updates.
MIT - see LICENSE file for details.
- 📖 Documentation
- 🐛 Bug Reports
- 💡 Feature Requests
- 💬 Community Discord
- n8n - Workflow automation platform
- Supabase - Open source Firebase alternative
- n8n Community Nodes
---
Made with ❤️ by the n8n community