DEPLOYMENT.md

🚀 Supabase Gradio Database Interface - Deployment Guide

This project creates a Gradio web interface for interacting with your Supabase PostgreSQL database.

📋 Features

• 📊 View Tables: Browse and display data from your database tables
• ➕ Add Data: Insert new records into sample tables
• 🔍 Custom Queries: Execute custom SQL queries
• 🔄 Real-time Updates: Refresh table lists and data
• 🛡️ Secure Connection: Uses environment variables for credentials

🛠️ Local Development Setup

1. Prerequisites

• Python 3.9+
• Conda (recommended)

2. Environment Setup

# Create conda environment
conda create -n superbase_gradio python=3.9 -y
conda activate superbase_gradio

# Install dependencies
pip install -r requirements.txt

3. Database Configuration

Set up your environment variables with your Supabase credentials:

export DB_HOST="db.bnjblzcqaumctpehgoid.supabase.co"
export DB_PORT="5432"
export DB_NAME="postgres"
export DB_USER="postgres"
export DB_PASSWORD="your_actual_password_here"
export HF_TOKEN="your_hf_token_here"

4. Test Connection

python test_connection.py

5. Run Locally

python app.py

Access the interface at: http://localhost:7860

🌐 Hugging Face Deployment

1. Push to Repository

# Add and commit all files
git add .
git commit -m "Initial Supabase Gradio interface"
git push origin main

2. Set Environment Variables

In your Hugging Face Space settings, add these secrets:

• DB_HOST: db.bnjblzcqaumctpehgoid.supabase.co
• DB_PORT: 5432
• DB_NAME: postgres
• DB_USER: postgres
• DB_PASSWORD: your_actual_supabase_password
• HF_TOKEN: your_hf_token_here

3. Repository Structure

testDB_full/
├── app.py                 # Main Gradio application
├── requirements.txt       # Python dependencies
├── config.py             # Configuration helper
├── test_connection.py    # Connection test script
├── README.md             # Hugging Face Space README
└── DEPLOYMENT.md         # This deployment guide

4. Deployment Process

1. Your Space will automatically rebuild when you push changes
2. The app will be available at: https://huggingface.co/spaces/Babajaan/testDB
3. Check the logs for any deployment issues

🔐 Security Notes

• Never commit passwords or sensitive credentials to the repository
• Always use environment variables for database credentials
• For production use, consider implementing authentication
• Limit database permissions for the connection user

🧪 Testing the Interface

1. View Tables: Select a table from the dropdown and view its data
2. Create Sample Table: Use the "Create Sample Table" button to set up test data
3. Add Records: Fill in the form to add new sample records
4. Custom Queries: Execute SELECT queries to explore your data

🆘 Troubleshooting

Common Issues:

1. Connection Failed: Check your database credentials and network connectivity
2. Table Not Found: Ensure the table exists and you have proper permissions
3. Deployment Issues: Check Hugging Face Space logs for specific errors

Debug Steps:

1. Run python test_connection.py locally first
2. Verify all environment variables are set correctly
3. Check database firewall settings allow connections from Hugging Face
4. Review application logs in Hugging Face Space settings

📚 Database Operations

The interface supports:

• SELECT: View and query data
• INSERT: Add new records (via forms)
• CREATE TABLE: Create sample tables for testing
• Custom SQL: Execute any SQL query (use with caution)

🔗 Useful Links

• Supabase Documentation
• Gradio Documentation
• Hugging Face Spaces

---

⚠️ Important: Remember to replace [YOUR-PASSWORD] with your actual Supabase database password!