Skip to content

[FEATURE] MCP bundles should include default env file plus additional server logging #691

Closed

Description

@jeffreyaven

Feature Description

  1. default env file

When --env.file is passed and the nominated path does not exist, stackql should create it at startup as an empty dotenv file with a short comment header, then continue as normal; if the file exists it must never be touched. This gives MCPB and other packaged installs a working out-of-the-box credential store: the bundle manifest can pass --env.file ${HOME}/.stackql/credentials.env unconditionally, the first launch creates the file, and the user populates it later and calls reload_credentials without restarting the client. Create-if-absent (rather than create-on-install or overwrite) is required because Claude Desktop replaces the extension directory on every update, and a version bump must not wipe populated credentials. For example, stackql mcp --mcp.server.type=stdio --env.file ~/.stackql/credentials.env on a clean machine would create:

# StackQL credential store, sourced at startup and on each reload_credentials call
# One KEY=VALUE per line, eg:
# AWS_ACCESS_KEY_ID=AKIA...
# AWS_SECRET_ACCESS_KEY=...

and a subsequent launch against the same path would leave the file untouched. File should be created 0600 on unix; behaviour applies to all entrypoints (exec, shell, srv, mcp) since --env.file is a root flag.

  1. Additional server logging

the server has had some unexpected termination, we need detailed information about this - if it is a panic or if it was terminated externally, we need more information than what we are getting:

2026-07-17T06:08:54.762Z [StackQL MCP Server] [info] Initializing server... { metadata: undefined }
2026-07-17T06:08:54.767Z [StackQL MCP Server] [info] Using MCP server command: C:\Users\javen\AppData\Roaming\Claude\Claude Extensions\local.mcpb.stackql-studios.io.github.stackqlstackql-mcp/server/stackql.exe with path: {
  metadata: {
    paths: [
      'C:\\Program Files\\nodejs',
      'C:\\Python312',
      'C:\\Program Files\\Git\\cmd',
      'C:\\Program Files\\Git\\mingw64\\bin',
      'C:\\Program Files\\Microsoft\\jdk-17.0.15.6-hotspot\\bin',
      'C:\\Python312\\Scripts\\',
      'C:\\Python312\\',
      'C:\\Windows\\system32',
      'C:\\Windows',
      'C:\\Windows\\System32\\Wbem',
      'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\',
      'C:\\Windows\\System32\\OpenSSH\\',
      'C:\\Program Files\\Docker\\Docker\\resources\\bin',
      'C:\\Program Files\\dotnet\\',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x64',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x32',
      'C:\\Program Files (x86)\\Google\\Cloud SDK\\google-cloud-sdk\\bin',
      'C:\\Program Files\\nodejs\\',
      'C:\\ProgramData\\chocolatey\\bin',
      'C:\\Program Files\\Rust stable MSVC 1.84\\bin',
      'C:\\Program Files\\Amazon\\AWSCLIV2\\',
      'C:\\Program Files\\Microsoft SQL Server\\170\\DTS\\Binn\\',
      'C:\\Program Files (x86)\\StackQL\\',
      'C:\\Users\\javen\\scoop\\shims',
      'C:\\Users\\javen\\AppData\\Local\\Microsoft\\WindowsApps',
      'C:\\Users\\javen\\AppData\\Local\\Programs\\Microsoft VS Code\\bin',
      'C:\\Users\\javen\\.dotnet\\tools',
      'C:\\Users\\javen\\AppData\\Roaming\\npm',
      'C:\\Program Files\\Java\\jdk-17\\bin',
      [length]: 29
    ]
  }
} %o
2026-07-17T06:08:55.108Z [StackQL MCP Server] [info] Server started and connected successfully { metadata: undefined }
2026-07-17T06:08:55.213Z [StackQL MCP Server] [info] Message from client: method="initialize" id=0 params { metadata: undefined }
2026-07-17T06:08:55.225Z [StackQL MCP Server] [info] Message from server: id=0 result { metadata: undefined }
2026-07-17T06:08:55.603Z [StackQL MCP Server] [info] Message from client: method="notifications/initialized" { metadata: undefined }
2026-07-17T06:08:55.605Z [StackQL MCP Server] [info] Message from client: method="tools/list" id=1 params { metadata: undefined }
2026-07-17T06:08:55.606Z [StackQL MCP Server] [info] Message from client: method="prompts/list" id=2 params { metadata: undefined }
2026-07-17T06:08:55.607Z [StackQL MCP Server] [info] Message from server: id=1 result { metadata: undefined }
2026-07-17T06:08:55.609Z [StackQL MCP Server] [info] Message from server: id=2 result { metadata: undefined }
2026-07-17T06:09:16.173Z [StackQL MCP Server] [info] Message from client: method="tools/call" id=3 params { metadata: undefined }
2026-07-17T06:09:16.262Z [StackQL MCP Server] [info] Message from server: id=3 result(1 blocks) { metadata: undefined }
2026-07-17T06:14:50.647Z [StackQL MCP Server] [info] Server transport closed { metadata: undefined }
2026-07-17T06:14:50.647Z [StackQL MCP Server] [info] Server transport closed unexpectedly, this is likely due to the process exiting early. If you are developing this MCP server you can add output to stderr (i.e. `console.error('...')` in JavaScript, `print('...', file=sys.stderr)` in python) and it will appear in this log. { metadata: undefined }
2026-07-17T06:14:50.648Z [StackQL MCP Server] [error] Server disconnected. For troubleshooting guidance, please visit our [debugging documentation](https://modelcontextprotocol.io/docs/tools/debugging) { metadata: { context: 'connection', stack: undefined } }
2026-07-17T06:14:50.648Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-17T06:14:50.648Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-17T06:15:31.442Z [StackQL MCP Server] [info] Initializing server... { metadata: undefined }
2026-07-17T06:15:31.449Z [StackQL MCP Server] [info] Using MCP server command: C:\Users\javen\AppData\Roaming\Claude\Claude Extensions\local.mcpb.stackql-studios.io.github.stackqlstackql-mcp/server/stackql.exe with path: {
  metadata: {
    paths: [
      'C:\\Program Files\\nodejs',
      'C:\\Python312',
      'C:\\Program Files\\Git\\cmd',
      'C:\\Program Files\\Git\\mingw64\\bin',
      'C:\\Program Files\\Microsoft\\jdk-17.0.15.6-hotspot\\bin',
      'C:\\Python312\\Scripts\\',
      'C:\\Python312\\',
      'C:\\Windows\\system32',
      'C:\\Windows',
      'C:\\Windows\\System32\\Wbem',
      'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\',
      'C:\\Windows\\System32\\OpenSSH\\',
      'C:\\Program Files\\Docker\\Docker\\resources\\bin',
      'C:\\Program Files\\dotnet\\',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x64',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x32',
      'C:\\Program Files (x86)\\Google\\Cloud SDK\\google-cloud-sdk\\bin',
      'C:\\Program Files\\nodejs\\',
      'C:\\ProgramData\\chocolatey\\bin',
      'C:\\Program Files\\Rust stable MSVC 1.84\\bin',
      'C:\\Program Files\\Amazon\\AWSCLIV2\\',
      'C:\\Program Files\\Microsoft SQL Server\\170\\DTS\\Binn\\',
      'C:\\Program Files (x86)\\StackQL\\',
      'C:\\Users\\javen\\scoop\\shims',
      'C:\\Users\\javen\\AppData\\Local\\Microsoft\\WindowsApps',
      'C:\\Users\\javen\\AppData\\Local\\Programs\\Microsoft VS Code\\bin',
      'C:\\Users\\javen\\.dotnet\\tools',
      'C:\\Users\\javen\\AppData\\Roaming\\npm',
      'C:\\Program Files\\Java\\jdk-17\\bin',
      [length]: 29
    ]
  }
} %o
2026-07-17T06:15:31.790Z [StackQL MCP Server] [info] Server started and connected successfully { metadata: undefined }
2026-07-17T06:15:32.348Z [StackQL MCP Server] [info] Message from client: method="initialize" id=0 params { metadata: undefined }
2026-07-17T06:15:32.354Z [StackQL MCP Server] [info] Message from server: id=0 result { metadata: undefined }
2026-07-17T06:15:32.486Z [StackQL MCP Server] [info] Message from client: method="notifications/initialized" { metadata: undefined }
2026-07-17T06:15:32.489Z [StackQL MCP Server] [info] Message from client: method="tools/list" id=1 params { metadata: undefined }
2026-07-17T06:15:32.489Z [StackQL MCP Server] [info] Message from client: method="prompts/list" id=2 params { metadata: undefined }
2026-07-17T06:15:32.491Z [StackQL MCP Server] [info] Message from server: id=2 result { metadata: undefined }
2026-07-17T06:15:32.529Z [StackQL MCP Server] [info] Message from server: id=1 result { metadata: undefined }
2026-07-17T06:16:08.758Z [StackQL MCP Server] [info] Message from client: method="tools/call" id=3 params { metadata: undefined }
2026-07-17T06:16:08.844Z [StackQL MCP Server] [info] Message from server: id=3 result(1 blocks) { metadata: undefined }
2026-07-20T09:26:09.974Z [StackQL MCP Server] [info] Initializing server... { metadata: undefined }
2026-07-20T09:26:09.986Z [StackQL MCP Server] [info] Using MCP server command: C:\Users\javen\AppData\Roaming\Claude\Claude Extensions\local.mcpb.stackql-studios.io.github.stackqlstackql-mcp/server/stackql.exe with path: {
  metadata: {
    paths: [
      'C:\\Program Files\\nodejs',
      'C:\\Python312',
      'C:\\Program Files\\Git\\cmd',
      'C:\\Program Files\\Git\\mingw64\\bin',
      'C:\\Program Files\\Microsoft\\jdk-17.0.15.6-hotspot\\bin',
      'C:\\Python312\\Scripts\\',
      'C:\\Python312\\',
      'C:\\Windows\\system32',
      'C:\\Windows',
      'C:\\Windows\\System32\\Wbem',
      'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\',
      'C:\\Windows\\System32\\OpenSSH\\',
      'C:\\Program Files\\Docker\\Docker\\resources\\bin',
      'C:\\Program Files\\dotnet\\',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x64',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x32',
      'C:\\Program Files (x86)\\Google\\Cloud SDK\\google-cloud-sdk\\bin',
      'C:\\Program Files\\nodejs\\',
      'C:\\ProgramData\\chocolatey\\bin',
      'C:\\Program Files\\Rust stable MSVC 1.84\\bin',
      'C:\\Program Files\\Amazon\\AWSCLIV2\\',
      'C:\\Program Files\\Microsoft SQL Server\\170\\DTS\\Binn\\',
      'C:\\Program Files (x86)\\StackQL\\',
      'C:\\Users\\javen\\scoop\\shims',
      'C:\\Users\\javen\\AppData\\Local\\Microsoft\\WindowsApps',
      'C:\\Users\\javen\\AppData\\Local\\Programs\\Microsoft VS Code\\bin',
      'C:\\Users\\javen\\.dotnet\\tools',
      'C:\\Users\\javen\\AppData\\Roaming\\npm',
      'C:\\Program Files\\Java\\jdk-17\\bin',
      [length]: 29
    ]
  }
} %o
2026-07-20T09:26:10.330Z [StackQL MCP Server] [info] Server started and connected successfully { metadata: undefined }
2026-07-20T09:26:11.283Z [StackQL MCP Server] [info] Message from client: method="initialize" id=0 params { metadata: undefined }
2026-07-20T09:26:11.286Z [StackQL MCP Server] [info] Message from server: id=0 result { metadata: undefined }
2026-07-20T09:26:12.345Z [StackQL MCP Server] [info] Message from client: method="notifications/initialized" { metadata: undefined }
2026-07-20T09:26:12.346Z [StackQL MCP Server] [info] Message from client: method="tools/list" id=1 params { metadata: undefined }
2026-07-20T09:26:12.347Z [StackQL MCP Server] [info] Message from client: method="prompts/list" id=2 params { metadata: undefined }
2026-07-20T09:26:12.348Z [StackQL MCP Server] [info] Message from server: id=1 result { metadata: undefined }
2026-07-20T09:26:12.348Z [StackQL MCP Server] [info] Message from server: id=2 result { metadata: undefined }
2026-07-20T09:26:22.936Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T09:26:22.936Z [StackQL MCP Server] [info] Server transport closed (renderer released port) { metadata: undefined }
2026-07-20T09:26:23.095Z [StackQL MCP Server] [info] Server transport closed { metadata: undefined }
2026-07-20T09:26:23.095Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T09:26:49.725Z [StackQL MCP Server] [info] Shutting down server... { metadata: undefined }
2026-07-20T09:26:49.725Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T09:26:49.725Z [StackQL MCP Server] [info] Initializing server... { metadata: undefined }
2026-07-20T09:26:49.728Z [StackQL MCP Server] [info] Using MCP server command: C:\Users\javen\AppData\Roaming\Claude\Claude Extensions\local.mcpb.stackql-studios.io.github.stackqlstackql-mcp/server/stackql.exe with path: {
  metadata: {
    paths: [
      'C:\\Program Files\\nodejs',
      'C:\\Python312',
      'C:\\Program Files\\Git\\cmd',
      'C:\\Program Files\\Git\\mingw64\\bin',
      'C:\\Program Files\\Microsoft\\jdk-17.0.15.6-hotspot\\bin',
      'C:\\Python312\\Scripts\\',
      'C:\\Python312\\',
      'C:\\Windows\\system32',
      'C:\\Windows',
      'C:\\Windows\\System32\\Wbem',
      'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\',
      'C:\\Windows\\System32\\OpenSSH\\',
      'C:\\Program Files\\Docker\\Docker\\resources\\bin',
      'C:\\Program Files\\dotnet\\',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x64',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x32',
      'C:\\Program Files (x86)\\Google\\Cloud SDK\\google-cloud-sdk\\bin',
      'C:\\Program Files\\nodejs\\',
      'C:\\ProgramData\\chocolatey\\bin',
      'C:\\Program Files\\Rust stable MSVC 1.84\\bin',
      'C:\\Program Files\\Amazon\\AWSCLIV2\\',
      'C:\\Program Files\\Microsoft SQL Server\\170\\DTS\\Binn\\',
      'C:\\Program Files (x86)\\StackQL\\',
      'C:\\Users\\javen\\scoop\\shims',
      'C:\\Users\\javen\\AppData\\Local\\Microsoft\\WindowsApps',
      'C:\\Users\\javen\\AppData\\Local\\Programs\\Microsoft VS Code\\bin',
      'C:\\Users\\javen\\.dotnet\\tools',
      'C:\\Users\\javen\\AppData\\Roaming\\npm',
      'C:\\Program Files\\Java\\jdk-17\\bin',
      [length]: 29
    ]
  }
} %o
2026-07-20T09:26:50.027Z [StackQL MCP Server] [info] Server started and connected successfully { metadata: undefined }
2026-07-20T09:26:50.129Z [StackQL MCP Server] [info] Message from client: method="initialize" id=0 params { metadata: undefined }
2026-07-20T09:26:50.149Z [StackQL MCP Server] [info] Message from server: id=0 result { metadata: undefined }
2026-07-20T09:26:50.181Z [StackQL MCP Server] [info] Message from client: method="notifications/initialized" { metadata: undefined }
2026-07-20T09:26:50.181Z [StackQL MCP Server] [info] Message from client: method="tools/list" id=1 params { metadata: undefined }
2026-07-20T09:26:50.181Z [StackQL MCP Server] [info] Message from client: method="prompts/list" id=2 params { metadata: undefined }
2026-07-20T09:26:50.182Z [StackQL MCP Server] [info] Message from server: id=1 result { metadata: undefined }
2026-07-20T09:26:50.183Z [StackQL MCP Server] [info] Message from server: id=2 result { metadata: undefined }
2026-07-20T10:49:40.524Z [StackQL MCP Server] [info] Server transport closed { metadata: undefined }
2026-07-20T10:49:40.525Z [StackQL MCP Server] [info] Server transport closed unexpectedly, this is likely due to the process exiting early. If you are developing this MCP server you can add output to stderr (i.e. `console.error('...')` in JavaScript, `print('...', file=sys.stderr)` in python) and it will appear in this log. { metadata: undefined }
2026-07-20T10:49:40.525Z [StackQL MCP Server] [error] Server disconnected. For troubleshooting guidance, please visit our [debugging documentation](https://modelcontextprotocol.io/docs/tools/debugging) { metadata: { context: 'connection', stack: undefined } }
2026-07-20T10:49:40.525Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T10:49:40.525Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T11:43:58.476Z [StackQL MCP Server] [info] Shutting down server... { metadata: undefined }
2026-07-20T11:43:58.476Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T11:46:52.569Z [StackQL MCP Server] [info] Initializing server... { metadata: undefined }
2026-07-20T11:46:52.572Z [StackQL MCP Server] [info] Using MCP server command: C:\Users\javen\AppData\Roaming\Claude\Claude Extensions\local.mcpb.stackql-studios.io.github.stackqlstackql-mcp/server/win32/stackql.exe with path: {
  metadata: {
    paths: [
      'C:\\Program Files\\nodejs',
      'C:\\Python312',
      'C:\\Program Files\\Git\\cmd',
      'C:\\Program Files\\Git\\mingw64\\bin',
      'C:\\Program Files\\Microsoft\\jdk-17.0.15.6-hotspot\\bin',
      'C:\\Python312\\Scripts\\',
      'C:\\Python312\\',
      'C:\\Windows\\system32',
      'C:\\Windows',
      'C:\\Windows\\System32\\Wbem',
      'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\',
      'C:\\Windows\\System32\\OpenSSH\\',
      'C:\\Program Files\\Docker\\Docker\\resources\\bin',
      'C:\\Program Files\\dotnet\\',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x64',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x32',
      'C:\\Program Files (x86)\\Google\\Cloud SDK\\google-cloud-sdk\\bin',
      'C:\\Program Files\\nodejs\\',
      'C:\\ProgramData\\chocolatey\\bin',
      'C:\\Program Files\\Rust stable MSVC 1.84\\bin',
      'C:\\Program Files\\Amazon\\AWSCLIV2\\',
      'C:\\Program Files\\Microsoft SQL Server\\170\\DTS\\Binn\\',
      'C:\\Program Files (x86)\\StackQL\\',
      'C:\\Users\\javen\\scoop\\shims',
      'C:\\Users\\javen\\AppData\\Local\\Microsoft\\WindowsApps',
      'C:\\Users\\javen\\AppData\\Local\\Programs\\Microsoft VS Code\\bin',
      'C:\\Users\\javen\\.dotnet\\tools',
      'C:\\Users\\javen\\AppData\\Roaming\\npm',
      'C:\\Program Files\\Java\\jdk-17\\bin',
      [length]: 29
    ]
  }
} %o
2026-07-20T11:46:53.577Z [StackQL MCP Server] [info] Server started and connected successfully { metadata: undefined }
2026-07-20T11:46:53.579Z [StackQL MCP Server] [info] Message from client: method="initialize" id=0 params { metadata: undefined }
2026-07-20T11:46:54.004Z [StackQL MCP Server] [info] Message from server: id=0 result { metadata: undefined }
2026-07-20T11:46:54.005Z [StackQL MCP Server] [info] Message from client: method="notifications/initialized" { metadata: undefined }
2026-07-20T11:46:54.005Z [StackQL MCP Server] [info] Message from client: method="tools/list" id=1 params { metadata: undefined }
2026-07-20T11:46:54.005Z [StackQL MCP Server] [info] Message from client: method="prompts/list" id=2 params { metadata: undefined }
2026-07-20T11:46:54.006Z [StackQL MCP Server] [info] Message from server: id=2 result { metadata: undefined }
2026-07-20T11:46:54.007Z [StackQL MCP Server] [info] Message from server: id=1 result { metadata: undefined }
2026-07-20T11:48:41.949Z [StackQL MCP Server] [info] Message from client: method="tools/call" id=3 params { metadata: undefined }
2026-07-20T11:48:42.045Z [StackQL MCP Server] [info] Message from server: id=3 result(1 blocks) { metadata: undefined }
2026-07-20T11:55:51.233Z [StackQL MCP Server] [info] Server transport closed { metadata: undefined }
2026-07-20T11:55:51.234Z [StackQL MCP Server] [info] Server transport closed unexpectedly, this is likely due to the process exiting early. If you are developing this MCP server you can add output to stderr (i.e. `console.error('...')` in JavaScript, `print('...', file=sys.stderr)` in python) and it will appear in this log. { metadata: undefined }
2026-07-20T11:55:51.234Z [StackQL MCP Server] [error] Server disconnected. For troubleshooting guidance, please visit our [debugging documentation](https://modelcontextprotocol.io/docs/tools/debugging) { metadata: { context: 'connection', stack: undefined } }
2026-07-20T11:55:51.234Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T11:55:51.234Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T22:37:06.450Z [StackQL MCP Server] [info] Shutting down server... { metadata: undefined }
2026-07-20T22:37:06.450Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T22:37:06.450Z [StackQL MCP Server] [info] Initializing server... { metadata: undefined }
2026-07-20T22:37:06.452Z [StackQL MCP Server] [info] Using MCP server command: C:\Users\javen\AppData\Roaming\Claude\Claude Extensions\local.mcpb.stackql-studios.io.github.stackqlstackql-mcp/server/win32/stackql.exe with path: {
  metadata: {
    paths: [
      'C:\\Program Files\\nodejs',
      'C:\\Python312',
      'C:\\Program Files\\Git\\cmd',
      'C:\\Program Files\\Git\\mingw64\\bin',
      'C:\\Program Files\\Microsoft\\jdk-17.0.15.6-hotspot\\bin',
      'C:\\Python312\\Scripts\\',
      'C:\\Python312\\',
      'C:\\Windows\\system32',
      'C:\\Windows',
      'C:\\Windows\\System32\\Wbem',
      'C:\\Windows\\System32\\WindowsPowerShell\\v1.0\\',
      'C:\\Windows\\System32\\OpenSSH\\',
      'C:\\Program Files\\Docker\\Docker\\resources\\bin',
      'C:\\Program Files\\dotnet\\',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x64',
      'C:\\Program Files\\SafeNet\\Authentication\\SAC\\x32',
      'C:\\Program Files (x86)\\Google\\Cloud SDK\\google-cloud-sdk\\bin',
      'C:\\Program Files\\nodejs\\',
      'C:\\ProgramData\\chocolatey\\bin',
      'C:\\Program Files\\Rust stable MSVC 1.84\\bin',
      'C:\\Program Files\\Amazon\\AWSCLIV2\\',
      'C:\\Program Files\\Microsoft SQL Server\\170\\DTS\\Binn\\',
      'C:\\Program Files (x86)\\StackQL\\',
      'C:\\Users\\javen\\scoop\\shims',
      'C:\\Users\\javen\\AppData\\Local\\Microsoft\\WindowsApps',
      'C:\\Users\\javen\\AppData\\Local\\Programs\\Microsoft VS Code\\bin',
      'C:\\Users\\javen\\.dotnet\\tools',
      'C:\\Users\\javen\\AppData\\Roaming\\npm',
      'C:\\Program Files\\Java\\jdk-17\\bin',
      [length]: 29
    ]
  }
} %o
2026-07-20T22:37:06.781Z [StackQL MCP Server] [info] Server started and connected successfully { metadata: undefined }
2026-07-20T22:37:06.860Z [StackQL MCP Server] [info] Message from client: method="initialize" id=0 params { metadata: undefined }
2026-07-20T22:37:06.897Z [StackQL MCP Server] [info] Message from server: id=0 result { metadata: undefined }
2026-07-20T22:37:07.379Z [StackQL MCP Server] [info] Message from client: method="notifications/initialized" { metadata: undefined }
2026-07-20T22:37:07.380Z [StackQL MCP Server] [info] Message from client: method="tools/list" id=1 params { metadata: undefined }
2026-07-20T22:37:07.380Z [StackQL MCP Server] [info] Message from client: method="prompts/list" id=2 params { metadata: undefined }
2026-07-20T22:37:07.381Z [StackQL MCP Server] [info] Message from server: id=2 result { metadata: undefined }
2026-07-20T22:37:07.382Z [StackQL MCP Server] [info] Message from server: id=1 result { metadata: undefined }
2026-07-20T22:38:26.830Z [StackQL MCP Server] [info] Message from client: method="tools/call" id=3 params { metadata: undefined }
2026-07-20T22:38:26.927Z [StackQL MCP Server] [info] Message from server: id=3 result(1 blocks) { metadata: undefined }
2026-07-20T22:38:32.567Z [StackQL MCP Server] [info] Message from client: method="tools/call" id=4 params { metadata: undefined }
2026-07-20T22:38:32.569Z [StackQL MCP Server] [info] Message from server: id=4 result(1 blocks) { metadata: undefined }
2026-07-20T22:39:08.829Z [StackQL MCP Server] [info] Message from client: method="tools/call" id=5 params { metadata: undefined }
2026-07-20T22:39:08.830Z [StackQL MCP Server] [info] Message from server: id=5 result(1 blocks) { metadata: undefined }
2026-07-20T22:40:41.790Z [StackQL MCP Server] [info] Message from client: method="tools/call" id=6 params { metadata: undefined }
2026-07-20T22:40:41.791Z [StackQL MCP Server] [info] Message from server: id=6 result(1 blocks) { metadata: undefined }
2026-07-20T22:42:24.004Z [StackQL MCP Server] [info] Server transport closed { metadata: undefined }
2026-07-20T22:42:24.004Z [StackQL MCP Server] [info] Server transport closed unexpectedly, this is likely due to the process exiting early. If you are developing this MCP server you can add output to stderr (i.e. `console.error('...')` in JavaScript, `print('...', file=sys.stderr)` in python) and it will appear in this log. { metadata: undefined }
2026-07-20T22:42:24.004Z [StackQL MCP Server] [error] Server disconnected. For troubleshooting guidance, please visit our [debugging documentation](https://modelcontextprotocol.io/docs/tools/debugging) { metadata: { context: 'connection', stack: undefined } }
2026-07-20T22:42:24.005Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }
2026-07-20T22:42:24.005Z [StackQL MCP Server] [info] Client transport closed { metadata: undefined }

all args the process was started with should be logged as well

Activity

  1. self-assigned this
    on Jul 20, 2026
  2. jeffreyaven commented on Jul 21, 2026

    @jeffreyaven
    MemberAuthor

    Implemented in #692 (merged to main).

    Default env file: when --env.file names a path that doesn't exist, stackql now creates it at startup as an empty commented dotenv file (0600 on unix, parent directories included, O_CREATE|O_EXCL). An existing file is never touched, so Claude Desktop extension updates cannot wipe populated credentials. Applies to all entrypoints (exec, shell, srv, mcp) since --env.file is a root flag. Covered by robot scenario Env File Flag Creates Default Empty File When Absent And Never Touches Existing plus unit tests.

    Server logging: the mcp entrypoint now emits timestamped diagnostics to stderr (captured by Claude Desktop's MCP log) regardless of --loglevel: startup line with version/platform/pid/transport and the full process args, panic recovery with stack trace, received-signal logging (exits 128+signum, so an external SIGTERM is distinguishable from a crash), and a terminal line distinguishing clean transport closure from a transport error.

    Rollout note: this ships in engine binaries from the next release; the MCPB manifests also need --env.file ${HOME}/.stackql/credentials.env added to their args before regenerated bundles pick this up.


    Generated by Claude Code

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions