10 Protocol Test Matrix
| Ecosystem | Protocol | Python Drivers | Auth (Phase 1) | Compatibility | Must-pass tests |
|---|---|---|---|---|---|
| PostgreSQL | libpq | psycopg2, asyncpg, SQLAlchemy | TLS + SCRAM | Gold | Connect, simple query, prepared stmt, cursor, tx, errors |
| MySQL | v10 | mysql-connector, PyMySQL, SQLAlchemy | TLS + native | Gold | Same as PG + autocommit semantics |
| Snowflake | HTTP/JSON subset | snowflake-connector | TLS + password | Silver | Session create, query submit, fetch, cancel |
| Databricks SQL | HTTP/Thrift subset | databricks-sql-connector | TLS + token | Silver | Connect, query, fetchmany |
| Pinecone | HTTP/gRPC subset | pinecone-client | TLS + API key | Silver | Upsert vectors, query top-k, filter |
| SQL Server | TDS 7.4 subset | pyodbc, pymssql | TLS + password | Bronze | Connect, simple query, param bind |
| DB2 | DRDA subset | ibm_db | TLS + password | Bronze | Connect, simple query |
| Oracle/Tibero | Net8/TTC subset | oracledb (Thin) | TLS + password | Bronze | Connect, select 1 from dual, bind |
CI should run these against every build; failures block merges.