pyconnector 0.3.0

Pluggable connectors for databases and services like Databricks, Postgres, SMTP, SFTP

🔌 pyconnector

pyconnector is a flexible, pluggable Python package designed to connect seamlessly to popular databases and services including Databricks, PostgreSQL, SMTP, and SFTP — using JDBC, ODBC, or native protocols.

Structure

. |-- LICENSE |-- README.md |-- build.sh |-- docs | |-- google.md | -- pyconnector.md |-- pyconnector | |-- core | | |-- base_db_connector.py | | -- base_google_connector.py | |-- databricks | | |-- init.py | | |-- api_connector.py | | |-- jdbc_connector.py | | |-- odbc_connector.py | | -- sql_connector.py | |-- driver_utils.py | |-- mysql | | |-- __init__.py | | -- connector.py | |-- postgres | | |-- init.py | | |-- api_connector.py | | |-- connector.py | | |-- jdbc_connector.py | | -- odbc_connector.py | |-- pygoogle | | |-- __init__.py | | |-- api_connector.py | | |-- drive_connector.py | | -- gmail_connector.py | |-- sftp | | |-- init.py | | -- basic_connector.py | |-- sharepoint | | |-- __init__.py | | -- api_connector.py | -- smtp | |-- __init__.py | -- basic_connector.py |-- pyproject.toml |-- requirements.txt |-- setup.cfg |-- token.pickle `-- token_gmail.pickle

11 directories, 35 files

✨ Features

• ✅ Multi-system support: Databricks, Postgres, SMTP, SFTP
• 🔄 Multi-mode: JDBC and ODBC connectors
• ⚙️ Dynamic driver versioning and loading
• 📦 Lightweight, modular, and extensible
• 🧩 Easy to plug in new systems

📦 Installation

pip install pyconnector


# 🔌 Included Connectors
Databricks
google - Gmail, Drive
MySql
Postgres

JDBC API, SQL. JDBc. ODBC Connector 

ODBC Connector

PostgreSQL

JDBC Connector

ODBC Connector

SMTP

Basic email sending support

SFTP

File upload/download over SSH

SHAREPOINT API Connector


#  Driver Management
All JDBC/ODBC drivers are stored in the local /drivers directory and loaded dynamically by:

system (e.g., databricks, postgres)

driver_type (jdbc or odbc)

version (optional; defaults to latest)