Back to Home
shayrylmae icon

AgriDatabase-MCP-Server

Verified Safe

by shayrylmae

Overview

Provides secure, read-only database access to an Agri-Geo Supabase database for AI assistants via the Model Context Protocol (MCP).

Installation

Run Command
npm run dev

Environment Variables

  • SUPABASE_URL
  • SUPABASE_ANON_KEY
  • PORT
  • NODE_ENV

Security Notes

The server uses Supabase client for database interactions, ensuring parameterized queries and preventing SQL injection. All tool arguments are validated using Zod schemas. It is designed for read-only access, with no INSERT/UPDATE/DELETE operations implemented. Environment variables are loaded via dotenv, preventing hardcoded secrets. Error handling appears to be safe, avoiding database schema leaks. No use of dangerous functions like 'eval' or direct child_process execution is observed. The SSE transport implements a connection registry with cleanup for stale sessions. The only minor point is the default permissive CORS for SSE ('Access-Control-Allow-Origin', '*') which should be restricted in production, as noted in the DEPLOYMENT.md.

Similar Servers

Stats

Interest Score0
Security Score9
Cost ClassMedium
Avg Tokens1500
Stars0
Forks0
Last Update2025-11-25

Tags

Agri-GeoSupabaseFarm ManagementAI ToolsData Access