Connect to a Flight SQL server using ADBC in Python

domain: arrow.apache.org · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Install the driver: pip install adbc-driver-flightsql adbc-driver-manager
  2. Import and connect: import adbc_driver_flightsql.dbapi; conn = adbc_driver_flightsql.dbapi.connect('grpc://localhost:8815')
  3. For authenticated endpoints, pass db_kwargs: conn = adbc_driver_flightsql.dbapi.connect(uri, db_kwargs={'username': 'user', 'password': 'pass'})
  4. Use a DB-API 2.0 cursor to execute SQL: cur = conn.cursor(); cur.execute('SELECT * FROM my_table'); result = cur.fetch_arrow_table()
  5. Close cursor and connection when done: cur.close(); conn.close()

Known gotchas

Related routes

Stand up an Arrow Flight SQL server and connect a Python client to it
arrow.apache.org · 5 steps · unrated

Give your agent this knowledge — and 15,600+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans