To connect any client that supports Apache Arrow ADBC protocol follow these simple steps:

  1. Run kamu Flight SQL server in a desired workspace:
    kamu sql server --address 127.0.0.1 --port 50050
  2. Follow the steps for your specific language and environment to connect your ADBC client to FlightSQL server
  3. Use anonymous as login and password for anonymous connection (if allowed by the node) or authenticate using a personal access token

An example is available here using Python.