Cline or Cursor cannot get the server started in windows / WSL issue with libpg-query

[Behappierre]

Bug report

Describe the bug

Cline has a question:
Please run npx --verbose -y @supabase/mcp-server-supabase@latest --access-token in WSL and share the output.

npx --verbose -y @supabase/mcp-server-supabase@latest --access-token

npm verbose cli /usr/bin/node /usr/lib/node_modules/npm/bin/npm-cli.js
npm info using [email protected]
npm info using [email protected]
npm verbose title npm exec @supabase/mcp-server-supabase@latest --access-token
npm verbose argv "exec" "--loglevel" "verbose" "--yes" "--" "@supabase/mcp-server-supabase@latest" "--access-token" " "
npm verbose logfile logs-max:10 dir:/.npm/_logs/2025-04-06T19_18_12_274Z-
npm verbose logfile /.npm/_logs/2025-04-06T19_18_12_274Z-debug-0.log
npm http fetch GET 200 https://registry.npmjs.org/@supabase%2fmcp-server-supabase 229ms (cache updated)
npm http fetch GET 200 https://registry.npmjs.org/@supabase%2fmcp-server-supabase 6ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@supabase%2fmcp-utils 13ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/postgres 13ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@modelcontextprotocol%2fsdk 16ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/openapi-fetch 17ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/zod-to-json-schema 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@gregnr%2fpostgres-meta 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/zod 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/common-tags 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@fastify%2fcors 16ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@fastify%2ftype-provider-typebox 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/crypto-js 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/close-with-grace 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fastify-metrics 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fastify 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@sinclair%2ftypebox 43ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-connection-string 54ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@fastify%2fswagger 58ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-format 58ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg 64ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pgsql-parser 61ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-protocol 69ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/content-type 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/prettier 64ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pino 74ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/cors 55ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/prettier-plugin-sql 70ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/postgres-array 91ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/eventsource 54ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/cross-spawn 56ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/express 50ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/express-rate-limit 45ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/raw-body 44ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/zod 41ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pkce-challenge 58ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/openapi-typescript-helpers 43ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-native 5ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/mnemonist 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fastify-plugin 26ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/json-schema-resolver 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/openapi-types 29ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pino 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/semver 37ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/rfdc 43ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/yaml 47ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/rfdc 50ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/avvio 50ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fastify-plugin 55ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/proxy-addr 52ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@fastify%2ferror 49ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/process-warning 42ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/toad-cache 56ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/find-my-way 57ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/abstract-logging 45ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@fastify%2fajv-compiler 36ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/light-my-request 47ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/secure-json-parse 46ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-content-type-parse 39ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-json-stringify 48ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@fastify%2ffast-json-stringify-compiler 39ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-pool 39ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pgpass 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-cloudflare 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/prom-client 48ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-types 48ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minimist 44ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/libpg-query 51ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/sonic-boom 40ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pgsql-deparser 50ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pgsql-enums 51ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-redact 43ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/atomic-sleep 42ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/real-require 42ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/thread-stream 41ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pino-std-serializers 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/on-exit-leak-free 39ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/quick-format-unescaped 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/safe-stable-stringify 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/jsox 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pino-abstract-transport 31ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/tslib 28ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/node-sql-parser 16ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/sql-formatter 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/obliterator 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/uri-js 8ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/debug 9ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/vary 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/shebang-command 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/path-key 20ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/qs 20ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/once 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/vary 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/send 25ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/etag 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/which 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/eventsource-parser 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/object-assign 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fresh 29ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/parseurl 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/accepts 26ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/router 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/body-parser 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/type-is 31ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/cookie 37ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/statuses 31ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/escape-html 26ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/mime-types 31ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/encodeurl 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/finalhandler 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/http-errors 31ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/on-finished 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/range-parser 28ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/merge-descriptors 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/serve-static 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/cookie-signature 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/content-disposition 25ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/http-errors 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/bytes 25ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/iconv-lite 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/unpipe 11ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/isexe 6ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/shebang-regex 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ms 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/depd 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/negotiator 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/safe-buffer 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/toidentifier 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/inherits 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/setprototypeof 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/wrappy 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ee-first 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/mime-db 25ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/forwarded 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ipaddr.js 15ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/path-to-regexp 12ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/media-typer 14ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/side-channel 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/is-promise 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/safer-buffer 2ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fastq 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-uri 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-deep-equal 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ajv 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-uri 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ajv-formats 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/json-schema-ref-resolver 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@fastify%2fmerge-json-schemas 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ajv 38ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/safe-regex2 40ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ajv-formats 49ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-querystring 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-deep-equal 37ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/set-cookie-parser 35ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/json-schema-traverse 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/require-from-string 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/reusify 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/tdigest 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fast-decode-uri-component 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ret 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/punycode 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/postgres-bytea 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/pg-int8 9ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/postgres-date 9ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/postgres-interval 10ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/split2 11ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/xtend 2ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/node-addon-api 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/node-gyp 11ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@pgsql%2ftypes 14ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/dotty 15ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@mapbox%2fnode-pre-gyp 17ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/nopt 14ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/make-dir 15ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/rimraf 20ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/detect-libc 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/tar 26ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/tar 28ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/node-fetch 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/glob 39ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/nopt 42ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/npmlog 48ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/https-proxy-agent 47ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/npmlog 42ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/rimraf 42ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/env-paths 38ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/graceful-fs 36ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/make-fetch-happen 34ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/encoding 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/agent-base 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/abbrev 20ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/whatwg-url 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/set-blocking 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/are-we-there-yet 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/mkdirp 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minipass 22ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/gauge 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/console-control-strings 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/yallist 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/chownr 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fs-minipass 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minizlib 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/tr46 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/webidl-conversions 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/inflight 17ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/fs.realpath 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ssri 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/is-lambda 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/promise-retry 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/cacache 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minipass-fetch 23ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/agentkeepalive 25ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minimatch 32ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/path-is-absolute 37ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/lru-cache 38ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/http-proxy-agent 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minipass-collect 30ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minipass-flush 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/socks-proxy-agent 29ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/http-cache-semantics 27ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minipass-pipeline 33ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/brace-expansion 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/infer-owner 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/humanize-ms 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/p-map 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/unique-filename 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@npmcli%2fmove-file 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/minipass-sized 15ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@tootallnate%2fonce 17ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@npmcli%2ffs 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/retry 16ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/err-code 17ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/promise-inflight 24ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/socks 10ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/aggregate-error 8ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/@gar%2fpromisify 9ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/unique-slug 8ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/balanced-match 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/concat-map 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/wide-align 14ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/delegates 16ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/strip-ansi 15ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/has-unicode 15ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/string-width 15ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/readable-stream 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/aproba 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/color-support 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/signal-exit 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/util-deprecate 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/string_decoder 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/emoji-regex 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ansi-regex 8ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/is-fullwidth-code-point 9ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/clean-stack 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/indent-string 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/process 5ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/abort-controller 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/events 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/buffer 12ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/get-stdin 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/argparse 6ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/nearley 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/big-integer 10ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/bintrees 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/side-channel-weakmap 8ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/side-channel-map 9ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/object-inspect 11ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/es-errors 12ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/side-channel-list 12ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/get-intrinsic 6ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/get-intrinsic 6ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/call-bound 8ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/call-bound 8ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/call-bind-apply-helpers 16ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/call-bind-apply-helpers 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/es-define-property 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/has-symbols 16ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/hasown 17ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/function-bind 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/es-object-atoms 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/math-intrinsics 18ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/gopd 19ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/get-proto 21ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/dunder-proto 2ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ip-address 6ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/smart-buffer 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/jsbn 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/sprintf-js 4ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/randexp 5ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/commander 7ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/moo 10ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/railroad-diagrams 10ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/discontinuous-range 3ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/imurmurhash 6ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/event-target-shim -154ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/ieee754 -153ms (cache hit)
npm http fetch GET 200 https://registry.npmjs.org/base64-js -151ms (cache hit)
npm http fetch POST 200 https://registry.npmjs.org/-/npm/v1/security/advisories/bulk 800ms
npm warn deprecated @npmcli/[email protected]: This functionality has been moved to @npmcli/fs
npm warn deprecated [email protected]: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and tested way to coalesce async requests by a key value, which is much more comprehensive and powerful.
npm warn deprecated [email protected]: This package is no longer supported.
npm warn deprecated [email protected]: This package is no longer supported.
npm warn deprecated [email protected]: Rimraf versions prior to v4 are no longer supported
npm warn deprecated [email protected]: This package is no longer supported.
npm warn deprecated [email protected]: This package is no longer supported.
npm warn deprecated [email protected]: Glob versions prior to v9 are no longer supported
npm warn deprecated [email protected]: This package is no longer supported.
npm warn deprecated [email protected]: This package is no longer supported.
npm info run [email protected] install node_modules/libpg-query node-pre-gyp install --fallback-to-build
npm info run [email protected] install { code: 1, signal: null }
npm verbose cwd /
npm verbose os Linux 5.15.167.4-microsoft-standard-WSL2
npm verbose node v20.19.0
npm verbose npm v10.8.2
npm verbose exit 1
npm verbose code 1

Thank you for providing the verbose output. Unfortunately, the logs confirm that the installation of the libpg-query dependency failed again, even within the WSL Ubuntu environment (code: 1).

This indicates a persistent issue with building or installing that specific native addon, which is required by the @supabase/mcp-server-supabase package. We've now tried:

Windows with Node v22
Windows with Node v20
Windows with Node v20 + C++ Build Tools + Developer Command Prompt
WSL (Ubuntu 24.04) with Node v20
Since the installation fails across these different environments and configurations, it strongly points towards an issue within the libpg-query package itself or its interaction with the build systems, rather than a simple configuration problem on your end.

At this stage, the most effective path forward is to report this detailed information (including the errors encountered on both Windows and WSL with Node v20) to the maintainers of the supabase-community/supabase-mcp project on GitHub. They will have the best understanding of the libpg-query dependency and its build requirements.

[Behappierre]

We have exhausted all reasonable troubleshooting steps, including those suggested in the image you provided.

We confirmed Node.js was installed on Windows.
We configured the MCP settings using your PAT.
We encountered build failures for the libpg-query dependency on Windows (Node v22 and v20), even after ensuring C++ build tools were installed and using the Developer Command Prompt.
We switched to using WSL (Ubuntu 24.04 with Node v20.19.0).
We installed node-gyp globally within WSL.
Running the npx command manually in WSL then succeeded in installing libpg-query.
However, configuring the MCP client to launch the server via wsl (both directly and using bash -ic) still resulted in a "Not connected" error, indicating the server process launched by the client isn't staying active or connecting correctly.
Despite the manual command working in WSL, the integration with the MCP client via wsl is proving unreliable. This could be due to subtle differences in environment variables or path settings between interactive and non-interactive WSL sessions, or other complexities in the VS Code -> WSL -> Node process execution.

Given the persistent difficulties across multiple environments and configurations, I must conclude that setting up this specific MCP server (@supabase/mcp-server-supabase) is not feasible with your current system setup without further investigation or fixes from the package maintainers.

Task Completed

I was unable to complete the setup of the Supabase MCP server. Despite extensive troubleshooting on both Windows and WSL (Ubuntu), including trying different Node.js versions, ensuring build tools were installed, using the Developer Command Prompt, installing node-gyp globally in WSL, and clearing caches, the MCP client consistently failed to connect to the server.

While we eventually got the required libpg-query dependency to install manually within WSL, the server process still does not run correctly when launched by the MCP client via wsl. This suggests deeper issues, potentially related to the build process of the native dependency or the interaction between the MCP client, WSL, and the server process's environment.

It is strongly recommended to report these persistent issues, detailing the steps taken and errors encountered on both Windows and WSL, to the supabase-community/supabase-mcp GitHub repository (https://github.com/supabase-community/supabase-mcp/issues) for maintainer assistance.

[tracyscott]

libpg-query had a build issue. The pre-built binaries it tries to use don't appear to be available anywhere (maybe because they are not actually buildable). Supabase should update the libpg-query dependency and push new pre-built binaries.

launchql/libpg-query-node#40

I updated the package.json and added an 'overrides' to force a newer version of libpg-query so that 'npm install' could successfully build the native library. The version being picked up from Supabase itself should be updated to 16.2.0? While technically not entirely correct until Supabase updates their dependency and tests the new libpg-query version... at least it runs and seems to be working. I also then just run it directly with node (v20.19.0). The 'overrides' change also allowed the server to run under WSL but I did not test having Cline talking to the WSL instance. I needed to install make, cc, g++, etc on my vanilla WSL Ubuntu instance. For native Windows, you will need some build tools to build the native library but it worked for me because I already have a lot of build tools installed.

My MCP config for Cline:

"supabase": {
      "command": "node",
      "args": [
        "C:\\Users\\youruser\\Documents\\Cline\\MCP\\supabase-mcp\\packages\\mcp-server-supabase\\dist\\stdio.js",
        "--access-token",
        "*your_access_token_here*"
      ]
    },

supabase-mcp repo's package.json with 'overrides' updates:

C:\Users\user\Documents\Cline\MCP\supabase-mcp>type package.json
{
  "workspaces": [
    "packages/*"
  ],
  "scripts": {
    "build": "npm run build --workspace @supabase/mcp-utils --workspace @supabase/mcp-server-supabase",
    "test": "npm run test --workspace @supabase/mcp-server-supabase"
  },
  "devDependencies": {
    "supabase": "^2.1.1"
  },
  "overrides": {
    "libpg-query": "16.2.0"
  }
}

After changing package.json, 'npm install' should succeed. And then 'npm run build' to build to the dist/ directory referenced in the MCP config above.

[tracyscott]

Tracked down some dependencies for reference...

supabase sql-to-rest is pulling in libpg-query ^15.1.0
https://github.com/supabase-community/sql-to-rest/blob/main/package.json

pgsql-parser 13.16.0 (the latest on npm) is at libpq-query 13.3.2 in package 'pgsql-parser'
https://github.com/launchql/pgsql-parser/blob/pgsql-parser%4013.16.0/packages/pgsql-parser/package.json

and just for fun, pgsql-parser 13.16.0 is at libpg-query 16.1.0 in package 'parser'
https://github.com/launchql/pgsql-parser/blob/pgsql-parser%4013.16.0/packages/parser/package.json

and an old pgsql-parser coming in via node_modules/@gregnr/postgres-meta in https://github.com/supabase-community/supabase-mcp/blob/main/package-lock.json
"pgsql-parser": "^13.3.0"

maybe it would be possible to depend on pgsql-parser/parser and pgsql-parser/deparser independently but
pgsql-parser/deparser has devDependencies:
"pgsql-parser": "^13.16.0",

https://github.com/launchql/pgsql-parser/blob/pgsql-parser%4013.16.0/packages/deparser/package.json

[amanat361]

Bumping this, having the same issue in both Cline and Cursor, WSL Ububtu

[gregnr]

Thanks everyone. We're working on removing the postgres-meta dependency entirely which is where libpg-query originally comes from. Will keep you posted.

[amanat361]

Thanks everyone. We're working on removing the postgres-meta dependency entirely which is where libpg-query originally comes from. Will keep you posted.

Thanks so much! Been dealing with this over the weekend and glad to hear it's getting fixed soon. Kudos

[gregnr]

Hey all, the fix has now been released (#43). Can you please try restarting your client (VS Code, Cursor, etc) and let me know if this fixes your issue?