SQLconnect is a Python package for data analysts that simplifies connecting to SQL databases like Postgres, Microsoft SQL Server and Oracle. DataFrames can be directly populated from .sql files, and database tables can be directly populated from DataFrames. A configuration file sqlconnect.yaml is used to store database connection details and an environment file sqlconnect.env is used for secure credential management. As a thin wrapper around SQLAlchemy and Pandas, SQLconnect provides convenient access to robust and flexible SQL operations.

Contents

User Guide

• Usage
  • Setup
    • sqlconnect.yaml
    • sqlconnect.env
  • Examples
    • Query from a file directly
    • Query from a Python string
    • Execute a SQL command from a file
    • Execute a SQL command from a Python string
    • Create a SQL database table from a DataFrame
• Documentation
  • Sqlconnector
    • Sqlconnector.connection_name
    • Sqlconnector.engine
    • Sqlconnector.df_to_sql()
    • Sqlconnector.execute_sql()
    • Sqlconnector.execute_sql_str()
    • Sqlconnector.sql_to_df()
    • Sqlconnector.sql_to_df_str()

Development

• Contributing
  • Development Environment
  • Making a Contribution
• Change Log
• Release History