How-to: launch aichat

[mattgagliardi]

Can anyone provide a brief step-by-step for running the aichat option? I've tried to get it working with multiple Docker containers as well as the installed Windows package...unfortunately the only output I seem to end up with is Error: Unknown command <aichat>. I've successfully connected to my DB with both Docker Compose setups and via the interactive shell...I feel like I kinda "get" what to do, which is why I'm really mystified here. TIA!

Have attempted this with:

• SchemaCrawler 16.26.3 (installed on Windows)
• schemacrawler/schemacrawler:early-access-release
• schemacrawler/schemacrawler-ai:early-access-release

My Docker Compose is:

services:

  schemacrawler:
    image: schemacrawler/schemacrawler:early-access-release
    stdin_open: true
    tty: true
    environment:
      OPENAI_API_KEY: "<valid_key>"
    volumes:
    - type: bind
      source: C:\Users\mattg\Documents\schcrwlr
      target: /home/schcrwlr
    entrypoint: [ '/opt/schemacrawler/bin/schemacrawler.sh' ]
    command: >
      --url 'jdbc:sqlserver://server-716.lan;instanceName=SQLSTD;databaseName=database1;encrypt=false'
      --user sa
      --password '<valid_pw>'
      --info-level standard
      --command aichat
      --log-level WARNING

[sualeh]

Sorry, @mattgagliardi - I have been so focused on the SchemaCrawler AI MCP Server, that I have not verified the "aichat" in a while. If you are interested in using the MCP Server, see schemacrawler/SchemaCrawler-MCP-Server-Usage on how to get started. If you prefer a shell, take a look at Microsoft AI Shell.

The only advantage that the "aichat" offers is that you can choose not to share your schema with the LLM. Other than that, I recommend using the MCP Server.

[sualeh]

@mattgagliardi I will take a look soon, though.

[sualeh]

@mattgagliardi Please see schemacrawler/SchemaCrawler-AI#80 for a resolution to your issue.