sql-tables

What problem does it solve?

This skill enables Python developers to read from and write to SQL tables directly from code, eliminating repetitive boilerplate and enabling clean data workflows in pipelines and notebooks.

Core Features & Use Cases

• Read: execute SQL queries and load results into pandas DataFrames with proper type handling.
• Write: safely persist DataFrames to database tables using explicit schema definitions and best practices for upserts.
• Use Case: Enrich a data pipeline by reading source tables, transforming in DataFrames, and writing results to a target table with minimal boilerplate.

Quick Start

Connect to your database using a URL from the environment or the OpenHEXA SDK, then read and write a table with Python:

• Read a table: df = pd.read_sql('SELECT * FROM my_table LIMIT 1000', engine)
• Write a table: df.to_sql(name='my_table_copy', con=engine, if_exists='replace', index=False)