Use a DB-API 2.0 cursor to execute SQL: cur = conn.cursor(); cur.execute('SELECT * FROM my_table'); result = cur.fetch_arrow_table()
Close cursor and connection when done: cur.close(); conn.close()
Known gotchas
adbc_driver_flightsql implements the DB-API 2.0 interface; it also exposes fetch_arrow_table() for zero-copy Arrow retrieval, which is more efficient than fetchall() for large results
The URI scheme must match the server's TLS configuration: grpc:// for plaintext, grpc+tls:// for TLS; a scheme mismatch produces an unhelpful gRPC channel error
ADBC drivers are versioned independently from pyarrow; always check the adbc-driver-flightsql changelog for breaking changes when upgrading either package
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp