error executing MCP supabase server for Cline in ubuntu under WSL Windows

[MarcoDR07]

Bug report

Describe the bug

the MCP server github.com/supabase-community/supabase-mcp is not working on Cline under Ubuntu in WSL (win 11).
I've tryed npx execution but no success.
When I try global install with npm (npm 10.8.2 node 20.19.0 i get the following error:

npm error src/postgres/src_port_snprintf.c:374:1: error: conflicting types for ‘strchrnul’; have ‘const char *(const char *, int)’
npm error 374 | strchrnul(const char *s, int c)
npm error | ^~~~~~~~~
npm error In file included from ./src/postgres/include/c.h:61,
npm error from src/postgres/src_port_snprintf.c:62:
npm error /usr/include/string.h:286:14: note: previous declaration of ‘strchrnul’ with type ‘char *(const char *, int)’
npm error 286 | extern char *strchrnul (const char *__s, int __c)
npm error | ^~~~~~~~~
npm error make[1]: *** [Makefile:172: src/postgres/src_port_snprintf.o] Error 1
npm error make: *** [queryparser.target.mk:13: libpg_query/include/pg_query.h] Error 1

To Reproduce

open ubuntu terminal
sudo npm install -g @supabase/mcp-server-supabase

Expected behavior

installation successful

Screenshots

If applicable, add screenshots to help explain your problem.

System information

Ubuntu 24.04 installation in WSL for Windows 11
Cline extension installed in VSCode inside Ubuntu distro
npm 10.8.2
node 20.19.0

Additional context

asked gemini on the issue this is the answer:

Node >= 20 Richiesto: Una dipendenza (@gregnr/postgres-meta) di @supabase/mcp-server-supabase@latest richiede Node.js 20 o superiore.

Nessun Binario Precompilato per Node 20: Supabase (o chi gestisce libpg-query) non fornisce binari precompilati per libpg-query compatibili con la tua combinazione di Node 20 (ABI v115) e Linux x64 (WSL/Ubuntu). Il log mostra chiaramente il 404 Not Found durante il tentativo di download.

Compilazione Fallita: Il fallback alla compilazione dai sorgenti fallisce a causa dell'errore C: conflicting types for ‘strchrnul’. Questo indica un'incompatibilità tra il codice sorgente di libpg-query (che include parti del codice sorgente di PostgreSQL) e le librerie C standard (header /usr/include/string.h) o il compilatore (gcc) presenti nel tuo ambiente Ubuntu/WSL aggiornato.

[gregnr]

Thanks for reporting @MarcoDR07. This should be fixed in #43, I'll update when that it merged and we publish a new release.

[gregnr]

The fix has now been released. Can you please try restarting VS Code and let me know if this fixes your issue?