About
Supabase MCP Server Self-Hosted provides 54+ administrative tools for managing private Supabase instances end-to-end, covering database operations, authentication, storage, real-time subscriptions, and schema migrations from a unified MCP interface. Key features include: - Secure SQL query execution with built-in injection prevention and safety checks - Database schema management, migration tools, and automated synchronization - Authentication and user management for Supabase Auth - File storage and bucket administration - Real-time data monitoring and log streaming - Row Level Security (RLS) policy validation and security audit helpers - Automated backup workflows and CRUD generation for rapid development - Flexible deployment options supporting Railway, Docker, and HTTP self-hosted setups - Production-grade performance optimization for managing multiple projects
Tools 53
execute_sqllist_tablescheck_healthlist_extensionsget_database_statsget_database_connectionsapply_migrationlist_migrationscreate_migrationvalidate_migrationpush_migrationssmart_migrationauto_migratesync_schemainspect_schemaimport_schemaexecute_psqlauto_create_indexesvacuum_analyzegenerate_typescript_typesgenerate_crud_apiget_logssearch_docsmetrics_dashboardanalyze_performanceanalyze_rls_coverageaudit_securitylist_auth_usersget_auth_usercreate_auth_userdelete_auth_userupdate_auth_usermanage_rolesmanage_rls_policiesverify_jwt_secretlist_storage_bucketslist_storage_objectsmanage_storage_policieslist_realtime_publicationsmanage_realtimecreate_subscriptiondelete_subscriptionmanage_extensionsmanage_functionsmanage_triggersmanage_webhooksrebuild_hooksmanage_secretscache_managementenvironment_managementget_project_urlget_anon_keyget_service_keyREADME
Supabase MCP Server - Self-Hosted Edition
🗄️ Serveur MCP Supabase Self-Hosted - Gestion complète de votre instance Supabase privée🌟 Fonctionnalités
🏗️ Architecture
Ce repository contient uniquement le serveur MCP Supabase pur, sans interface web ni hub central. ``
Supabase MCP Server (Port 8000)
├── 🗄️ Gestion de base de données
├── 🔐 Authentification et autorisation
├── 📁 Stockage et fichiers
├── 🔄 Temps réel et subscriptions
├── 🛠️ Migrations et schémas
├── 📊 Monitoring et logs
└── 🚀 Déploiement automatique
`
🚀 Démarrage Rapide
Prérequis
Python 3.11+
Instance Supabase (self-hosted ou cloud)
Variables d'environnement Supabase
Option A — SDK Smithery (recommandé)
`bash
Cloner le repository
git clone https://github.com/MisterSandFR/Supabase-MCP-SelfHosted.git
cd Supabase-MCP-SelfHosted
Installer les dépendances
pip install -r requirements.txt
(Facultatif) Installer la CLI Smithery si besoin
npm i -g @smithery/cli
Lancer le dev SDK (selon votre environnement)
smithery dev # ou: smithery playground
`
Le serveur SDK est défini dans pyproject.toml via:
- [tool.smithery] server = "supabase_mcp_server.server:create_server"
Lors du déploiement dans l’interface Smithery, configurez le Test Profile puis lancez le Scan.
Option B — HTTP self-hosted (compat)
`bash
Cloner le repository
git clone https://github.com/MisterSandFR/Supabase-MCP-SelfHosted.git
cd Supabase-MCP-SelfHosted
Installer les dépendances Python
pip install -r requirements.txt
Configurer les variables d'environnement
export SUPABASE_URL="https://your-project.supabase.co"
export SUPABASE_ANON_KEY="your-anon-key"
export SUPABASE_SERVICE_KEY="your-service-key" # Optionnel
Démarrer le serveur HTTP externe
python src/supabase_server.py
`
Avec Docker (Railway / self-hosted)
`bash
Build et démarrage (utilisez Dockerfile.railway si besoin)
docker build -f Dockerfile.railway -t supabase-mcp-server .
docker run -p 8000:8000 \
-e SUPABASE_URL="https://your-project.supabase.co" \
-e SUPABASE_ANON_KEY="your-anon-key" \
supabase-mcp-server
`
⚙️ Configuration
Variables d'Environnement
`bash
Supabase Configuration
SUPABASE_URL=https://your-project.supabase.co
SUPABASE_ANON_KEY=eyJ... (votre clé anonyme)
SUPABASE_SERVICE_KEY=eyJ... (optionnel, pour opérations privilégiées)
Server Configuration
PORT=8000
PYTHONUNBUFFERED=1
`
🛠️ Outils MCP Disponibles
Base de Données (15 outils)
execute_sql - Exécution de requêtes SQL
list_tables - Liste des tables
inspect_schema - Inspection du schéma
apply_migration - Application de migrations
backup_database - Sauvegarde de base
restore_database - Restauration de base
vacuum_analyze - Optimisation de base
get_database_stats - Statistiques de base
create_index - Création d'index
drop_index - Suppression d'index
list_extensions - Liste des extensions
manage_extensions - Gestion des extensions
execute_psql - Commandes psql
check_health - Vérification de santé
get_database_connections - Connexions de base
Authentification (8 outils)
list_auth_users - Liste des utilisateurs
create_auth_user - Création d'utilisateur
update_auth_user - Mise à jour d'utilisateur
delete_auth_user - Suppression d'utilisateur
get_auth_user - Récupération d'utilisateur
verify_jwt_secret - Vérification JWT
manage_roles - Gestion des rôles
manage_rls_policies - Gestion des politiques RLS
Stockage (6 outils)
list_storage_buckets - Liste des buckets
list_storage_objects - Liste des objets
manage_storage_policies - Gestion des politiques
upload_file - Upload de fichier
download_file - Téléchargement de fichier
delete_file - Suppression de fichier
Temps Réel (4 outils)
list_realtime_publications - Liste des publications
manage_realtime - Gestion du temps réel
create_subscription - Création de subscription
delete_subscription - Suppression de subscription
Migrations (8 outils)
create_migration - Création de migration
list_migrations - Liste des migrations
push_migrations - Push des migrations
validate_migration - Validation de migration
smart_migration - Migration intelligente
auto_migrate - Migration automatique
sync_schema - Synchronisation de schéma
import_schema - Import de schéma
Monitoring (5 outils)
get_logs - Récupération des logs
metrics_dashboard` - Tableau de bord métriqRelated MCP Servers
AI Research Assistant
hamid-vakilzadeh
AI Research Assistant provides comprehensive access to millions of academic papers through the Semantic Scholar and arXiv databases. This MCP server enables AI coding assistants to perform intelligent literature searches, citation network analysis, and paper content extraction without requiring an API key. Key features include: - Advanced paper search with multi-filter support by year ranges, citation thresholds, field of study, and publication type - Title matching with confidence scoring for finding specific papers - Batch operations supporting up to 500 papers per request - Citation analysis and network exploration for understanding research relationships - Full-text PDF extraction from arXiv and Wiley open-access content (Wiley TDM token required for institutional access) - Rate limits of 100 requests per 5 minutes with options to request higher limits through Semantic Scholar
Math-MCP
EthanHenrickson
Math-MCP is a computation server that enables Large Language Models (LLMs) to perform accurate numerical calculations through the Model Context Protocol. It provides precise mathematical operations via a simple API to overcome LLM limitations in arithmetic and statistical reasoning. Key features of Math-MCP: - Basic arithmetic operations: addition, subtraction, multiplication, division, modulo, and bulk summation - Statistical analysis functions: mean, median, mode, minimum, and maximum calculations - Rounding utilities: floor, ceiling, and nearest integer rounding - Trigonometric functions: sine, cosine, tangent, and their inverses with degrees and radians conversion support
Saju Insights
hjsh200219
Saju Insights provides personalized Korean traditional Four Pillars of Destiny (Saju) fortune-telling based on birth data. It calculates destiny charts using the eight characters (four heavenly stems and four earthly branches) derived from birth year, month, day, and hour. Key capabilities include: - Birth chart calculation with automatic True Solar Time adjustment (Jintaeyangsi -30min correction) - Fortune analysis covering personality, career, wealth, health, and love prospects - Relationship compatibility analysis comparing two people's Saju charts - 10-year luck cycle (Daewon) predictions for long-term planning - Yongsin (favorable element) guidance on lucky colors, directions, and career paths - Lunar-solar calendar conversion supporting 1900-2200 with leap month handling - Daily fortune readings and seasonal power calculations - Multiple interpretation schools including Ziping, DTS, and modern methodologies