[{"_1":2,"_367":-5,"_368":-5},"loaderData",{"_3":4,"_53":54,"_55":56,"_57":58,"_280":281},"root",{"_5":6,"_49":50,"_51":52},"appGlobal",{"_7":8,"_38":39,"_40":41},"config",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":-5,"_24":25,"_26":27,"_28":29,"_30":31,"_32":33,"_34":31,"_35":31,"_36":37},"APP_URL","https://glama.ai","CLIENT_ASSETS_URL","https://static.glama.ai/client/","ENVIRONMENT","LIVE","FACEBOOK_PIXEL_ID","1988603181578092","GOOGLE_ANALYTICS_MEASUREMENT_ID","G-GDQ5NW5CB5","GOOGLE_OAUTH2_CLIENT_ID","48173796263-7ohlqirg28gh2a7nel61coff3m1ogjtc.apps.googleusercontent.com","INTERCOM_APP_ID","wgcqevfz","INTERCOM_USER_HASH","POSTHOG_API_KEY","phc_aK0RnJxBEBRE0h0LIz21yyc9w6ylBxwUHMPB4712Bjc","REDDIT_PIXEL_ID","a2_fcqsoymvje51","RELEASE_VERSION","glama@fe0ec19","SENTRY_DRY_RUN",false,"SENTRY_DSN","https://fc82aa9f808b13927ff29c56bda4d486@o4507975513735168.ingest.us.sentry.io/4507975514849280","SENTRY_SPOTLIGHT","SENTRY_TRACE","STRIPE_PUBLIC_KEY","pk_live_51QpZQ32LV3sZcHqzHlFuNhgSfggSNaQqCzZw9EMJ8tbhpQyZgcwQj1vz168FxQ35EGRcztKu2MankxiSs7zLCF4g00blUverGs","viewportWidth",1280,"visitorSession",{"_42":43,"_45":-5,"_46":47,"_48":-5},"attributes",[44],"BOT","membership","uid","yq0ihqGHeh","userAccount","nonce","b26c689002b88771ed46a3262c8dda43","toasts",[],"routes/_public/_layout",{},"routes/_public/mcp/servers/~uid/_layout",{},"routes/_public/mcp/servers/~uid/_pages/_layout",{"_59":-5,"_60":61,"_199":200},"githubUser","mcpServer",{"_62":63,"_64":65,"_42":80,"_85":86,"_87":86,"_88":89,"_94":95,"_114":115,"_116":117,"_118":119,"_120":-5,"_121":-5,"_122":123,"_124":125,"_129":-5,"_130":131,"_137":-5,"_138":139,"_143":144,"_46":196,"_197":198},"addedAt",["D",1741479252085],"argumentsJsonSchema",{"_66":67,"_68":69,"_72":73},"type","object","required",[70,71],"SUPABASE_URL","SUPABASE_KEY","properties",{"_71":74,"_70":78},{"_66":75,"_76":77},"string","description","Your Supabase service_role key (NOT the anon key)",{"_66":75,"_76":79},"Your Supabase project URL (e.g., https://your-project.supabase.co or http://localhost:54321 for local projects)",[81,82,83,84],"category:databases","category:developer-tools","hosting:hybrid","language:javascript","descriptionMarkdown","Enables querying Supabase databases and generating TypeScript types through the Model Context Protocol interface, supporting features like schema selection, column filtering, and pagination.","descriptionPlainText","githubProject",{"_90":91,"_92":93},"readme","# Supabase MCP Server\n\nA Model Context Protocol (MCP) server for interacting with Supabase databases. This server provides tools for querying tables and generating TypeScript types through the MCP interface.\n\n## Features\n\n- **Query Tables**: Execute queries on any table with support for:\n - Schema selection\n - Column filtering\n - Where clauses with multiple operators\n - Pagination\n - Error handling\n\n- **Type Generation**: Generate TypeScript types for your database:\n - Support for any schema (public, auth, api, etc.)\n - Works with both local and remote Supabase projects\n - Direct output to console\n - Automatic project reference detection\n\n## Prerequisites\n\n1. Node.js (v16 or higher)\n2. A Supabase project (either local or hosted)\n3. Supabase CLI (for type generation)\n\n## Installation\n\n1. Clone the repository:\n```bash\ngit clone https://github.com/yourusername/supabase-mcp-server.git\ncd supabase-mcp-server\n```\n\n2. Install dependencies:\n```bash\nnpm install\n```\n\n3. Install the Supabase CLI (required for type generation):\n```bash\n# Using npm\nnpm install -g supabase\n\n# Or using Homebrew on macOS\nbrew install supabase/tap/supabase\n```\n\n## Configuration\n\n1. Get your Supabase credentials:\n - For hosted projects:\n 1. Go to your Supabase project dashboard\n 2. Navigate to Project Settings > API\n 3. Copy the Project URL and service_role key (NOT the anon key)\n \n - For local projects:\n 1. Start your local Supabase instance\n 2. Use the local URL (typically http://localhost:54321)\n 3. Use your local service_role key\n\n2. Configure environment variables:\n```bash\n# Create a .env file (this will be ignored by git)\necho \"SUPABASE_URL=your_project_url\nSUPABASE_KEY=your_service_role_key\" > .env\n```\n\n3. Build the server:\n```bash\nnpm run build\n```\n\n## Integration with Claude Desktop\n\n1. Open Claude Desktop settings:\n - macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`\n - Windows: `%APPDATA%\\Claude\\claude_desktop_config.json`\n - Linux: `~/.config/Claude/claude_desktop_config.json`\n\n2. Add the server configuration:\n```json\n{\n \"mcpServers\": {\n \"supabase\": {\n \"command\": \"node\",\n \"args\": [\"/absolute/path/to/supabase-mcp-server/build/index.js\"],\n \"env\": {\n \"SUPABASE_URL\": \"your_project_url\",\n \"SUPABASE_KEY\": \"your_service_role_key\"\n }\n }\n }\n}\n```\n\n## Integration with VSCode Extension\n\n1. Open VSCode settings:\n - macOS: `~/Library/Application Support/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json`\n - Windows: `%APPDATA%\\Code\\User\\globalStorage\\saoudrizwan.claude-dev\\settings\\cline_mcp_settings.json`\n - Linux: `~/.config/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json`\n\n2. Add the server configuration (same format as Claude Desktop).\n\n## Usage Examples\n\n### Querying Tables\n\n```typescript\n// Query with schema selection and where clause\n\nsupabase\nquery_table\n\n{\n \"schema\": \"public\",\n \"table\": \"users\",\n \"select\": \"id,name,email\",\n \"where\": [\n {\n \"column\": \"is_active\",\n \"operator\": \"eq\",\n \"value\": true\n }\n ]\n}\n\n\n```\n\n### Generating Types\n\n```typescript\n// Generate types for public schema\n\nsupabase\ngenerate_types\n\n{\n \"schema\": \"public\"\n}\n\n\n```\n\n## Available Tools\n\n### query_table\nQuery a specific table with schema selection and where clause support.\n\nParameters:\n- `schema` (optional): Database schema (defaults to public)\n- `table` (required): Name of the table to query\n- `select` (optional): Comma-separated list of columns\n- `where` (optional): Array of conditions with:\n - `column`: Column name\n - `operator`: One of: eq, neq, gt, gte, lt, lte, like, ilike, is\n - `value`: Value to compare against\n\n### generate_types\nGenerate TypeScript types for your Supabase database schema.\n\nParameters:\n- `schema` (optional): Database schema (defaults to public)\n\n## Troubleshooting\n\n### Type Generation Issues\n\n1. Ensure Supabase CLI is installed:\n```bash\nsupabase --version\n```\n\n2. For local projects:\n - Make sure your local Supabase instance is running\n - Verify your service_role key is correct\n\n3. For hosted projects:\n - Confirm your project ref is correct (extracted from URL)\n - Verify you're using the service_role key, not the anon key\n\n### Query Issues\n\n1. Check your schema and table names\n2. Verify column names in select and where clauses\n3. Ensure your service_role key has necessary permissions\n\n## Contributing\n\n1. Fork the repository\n2. Create your feature branch: `git checkout -b feature/my-feature`\n3. Commit your changes: `git commit -am 'Add my feature'`\n4. Push to the branch: `git push origin feature/my-feature`\n5. Submit a pull request\n\n## License\n\nMIT License - see LICENSE file for details\n","url","https://github.com/NightTrek/Supabase-MCP","githubRepository",{"_96":97,"_98":99,"_100":101,"_102":103,"_104":105,"_109":110,"_111":-5,"_112":113},"defaultBranch","main","fullName","NightTrek/Supabase-MCP","githubTreeId",74095,"language","JavaScript","owner",{"_106":107,"_108":31},"login","NightTrek","verified","recentStargazers",1,"spdxLicense","stargazers",5,"id",1495,"inspectable",true,"name","Supabase MCP Server","npmPackage","prompts","redditPostForeignId","1j6vlhd","relatedMcpServerIds",[126,127,128,128,128,128],547,952,546,"resources","scores",{"_132":133,"_134":135,"_136":135},"license",0,"quality",100,"security","simpleIcon","supportedPlatforms",[140,141,142],"WINDOWS","MACOS","LINUX","tools",[145,190],{"_118":146,"_76":147,"_148":149},"query_table","Query a specific table with schema selection and where clause support","inputSchema",{"_66":67,"_68":150,"_72":152},[151],"table",{"_151":153,"_155":156,"_184":185,"_187":188},{"_66":75,"_76":154},"Name of the table to query","where",{"_66":157,"_158":159,"_76":183},"array","items",{"_66":67,"_68":160,"_72":164},[161,162,163],"column","operator","value",{"_163":165,"_161":168,"_162":170},{"_66":166,"_76":167},"any","Value to compare against",{"_66":75,"_76":169},"Column name",{"_171":172,"_66":75,"_76":182},"enum",[173,174,175,176,177,178,179,180,181],"eq","neq","gt","gte","lt","lte","like","ilike","is","Comparison operator","Array of where conditions (optional)","schema",{"_66":75,"_76":186},"Database schema (optional, defaults to public)","select",{"_66":75,"_76":189},"Comma-separated list of columns to select (optional, defaults to *)",{"_118":191,"_76":192,"_148":193},"generate_types","Generate TypeScript types for your Supabase database schema",{"_66":67,"_72":194},{"_184":195},{"_66":75,"_76":186},"wjmmfri9rj","updatedAt",["D",1741568499628],"meta",[201,204,206,213,216,218,221,224,227,230,233,235,238,241,243,245,247,249,251],{"_202":203},"title","Supabase MCP Server | Glama",{"_205":86,"_118":76},"content",{"_207":208,"_209":210,"_211":212},"href","https://glama.ai/mcp/servers/wjmmfri9rj","rel","canonical","tagName","link",{"_205":119,"_214":215},"property","og:title",{"_205":86,"_214":217},"og:description",{"_205":219,"_214":220},"https://glama.ai/logo.png","og:logo",{"_205":222,"_214":223},"https://glama.ai/mcp/servers/wjmmfri9rj/og-image","og:image",{"_205":225,"_214":226},"630","og:image:height",{"_205":228,"_214":229},"1200","og:image:width",{"_205":231,"_214":232},"website","og:type",{"_205":208,"_214":234},"og:url",{"_205":236,"_214":237},"ChatGPT alternative for power users","og:site_name",{"_205":239,"_118":240},"summary_large_image","twitter:card",{"_205":236,"_118":242},"twitter:title",{"_205":86,"_118":244},"twitter:description",{"_205":222,"_118":246},"twitter:image",{"_205":225,"_118":248},"twitter:image:height",{"_205":228,"_118":250},"twitter:image:width",{"_252":253},"script:ld+json",{"_254":255,"_256":257},"@context","http://schema.org","@graph",[258],{"_254":259,"_260":261,"_262":263},"https://schema.org","@type","BreadcrumbList","itemListElement",[264,270,274,278],{"_260":265,"_266":267,"_118":268,"_269":110},"ListItem","item","https://glama.ai/","Glama","position",{"_260":265,"_266":271,"_118":272,"_269":273},"https://glama.ai/mcp","MCP",2,{"_260":265,"_266":275,"_118":276,"_269":277},"https://glama.ai/mcp/servers","Servers",3,{"_260":265,"_266":208,"_118":119,"_269":279},4,"routes/_public/mcp/servers/~uid/_pages/tools/~name/_route",{"_60":282,"_317":-5,"_318":319,"_199":324,"_360":361,"_40":366},{"_62":283,"_64":284,"_42":289,"_85":86,"_87":86,"_88":290,"_94":291,"_114":115,"_116":117,"_118":119,"_120":-5,"_121":-5,"_122":123,"_124":293,"_129":-5,"_130":294,"_137":-5,"_138":295,"_143":296,"_46":196,"_197":316},["D",1741479252085],{"_66":67,"_68":285,"_72":286},[70,71],{"_71":287,"_70":288},{"_66":75,"_76":77},{"_66":75,"_76":79},[81,82,83,84],{"_90":91,"_92":93},{"_96":97,"_98":99,"_100":101,"_102":103,"_104":292,"_109":110,"_111":-5,"_112":113},{"_106":107,"_108":31},[126,127,128,128,128,128],{"_132":133,"_134":135,"_136":135},[140,141,142],[297,312],{"_118":146,"_76":147,"_148":298},{"_66":67,"_68":299,"_72":300},[151],{"_151":301,"_155":302,"_184":310,"_187":311},{"_66":75,"_76":154},{"_66":157,"_158":303,"_76":183},{"_66":67,"_68":304,"_72":305},[161,162,163],{"_163":306,"_161":307,"_162":308},{"_66":166,"_76":167},{"_66":75,"_76":169},{"_171":309,"_66":75,"_76":182},[173,174,175,176,177,178,179,180,181],{"_66":75,"_76":186},{"_66":75,"_76":189},{"_118":191,"_76":192,"_148":313},{"_66":67,"_72":314},{"_184":315},{"_66":75,"_76":186},["D",1741568499628],"mcpServerInstance","mcpServerTool",{"_76":192,"_114":320,"_148":321,"_118":191},15232,{"_72":322,"_66":67},{"_184":323},{"_76":186,"_66":75},[325,327,328,329,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345],{"_202":326},"generate_types - Supabase MCP Server | Glama",{"_205":192,"_118":76},{"_207":208,"_209":210,"_211":212},{"_205":330,"_214":215},"generate_types - Supabase MCP Server",{"_205":192,"_214":217},{"_205":219,"_214":220},{"_205":222,"_214":223},{"_205":225,"_214":226},{"_205":228,"_214":229},{"_205":231,"_214":232},{"_205":208,"_214":234},{"_205":236,"_214":237},{"_205":239,"_118":240},{"_205":236,"_118":242},{"_205":192,"_118":244},{"_205":222,"_118":246},{"_205":225,"_118":248},{"_205":228,"_118":250},{"_252":346},{"_254":255,"_256":347},[348],{"_254":259,"_260":261,"_262":349},[350,351,352,353,354,357],{"_260":265,"_266":267,"_118":268,"_269":110},{"_260":265,"_266":271,"_118":272,"_269":273},{"_260":265,"_266":275,"_118":276,"_269":277},{"_260":265,"_266":208,"_118":119,"_269":279},{"_260":265,"_266":355,"_118":356,"_269":113},"https://glama.ai/mcp/servers/wjmmfri9rj/tools","Tools",{"_260":265,"_266":358,"_118":191,"_269":359},"https://glama.ai/mcp/servers/wjmmfri9rj/tools/generate_types",6,"otherTools",[362,364],{"_60":363,"_118":191},{"_46":196},{"_60":365,"_118":146},{"_46":196},{"_48":-5},"actionData","errors"]

generate_types

Input Schema

Input Schema (JSON Schema)

Other Tools