Glossary · Integration

Database Connector

A software component that enables applications to connect and communicate with specific database systems.

A database connector (or driver) is a software component that enables an application to establish a connection to a specific database system and communicate with it. Connectors handle the low-level details of the database protocol: authentication, connection management, query transmission, result parsing, error handling, and type mapping. Each database system has its own wire protocol and requires a corresponding connector. Common connector types include JDBC (Java Database Connectivity), ODBC (Open Database Connectivity), and language-specific drivers (pg for Node.js/PostgreSQL, psycopg2 for Python/PostgreSQL, mysql2 for Node.js/MySQL). Connectors are the foundation of any tool that interacts with databases.

Fig — every answer ships with the tables, rows and SQL behind it.