Install ADBC with a compatible driver, e.g. pip install adbc-driver-postgresql adbc-driver-manager for PostgreSQL
Open a connection and obtain a low-level AdbcConnection via the driver manager, or use the dbapi interface
Prepare an Arrow Table or RecordBatch containing the data to ingest
Using the DB-API cursor's adbc_ingest method: cur.adbc_ingest('target_table', arrow_table, mode='create_append')
Commit the transaction if the connection is not in autocommit mode: conn.commit()
Known gotchas
The adbc_ingest mode parameter accepts 'create' (fail if table exists), 'create_append' (create or append), and 'append' (fail if table does not exist); using the wrong mode will either drop existing data or raise an error
Column names and types in the Arrow schema are mapped to the target table; type mismatches between Arrow and the target database type system can cause silent truncation or explicit errors depending on the driver
Not all ADBC drivers implement bulk ingest; consult the driver's documentation before assuming adbc_ingest is available for your backend
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