Read and write SQL tables from Python using SQLAlchemy and pandas.
npx skills add https://github.com/BLSQ/mcp_servers --skill sql-tables
Please help me install this Agent Skill. Skill: sql-tables Source: https://github.com/BLSQ/mcp_servers/tree/main/.claude/skills/sql-tables Command: npx skills add https://github.com/BLSQ/mcp_servers --skill sql-tables
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.
Connect to your database using a URL from the environment or the OpenHEXA SDK, then read and write a table with Python:
High-intent search queries and answers about installing and using this skill.
To read SQL tables into pandas DataFrames, execute SQL queries using SQLAlchemy and pandas, which loads results with proper type handling. This streamlines data workflows in pipelines and notebooks by eliminating repetitive boilerplate.
The best way to write pandas DataFrames to SQL tables is using explicit schema definitions for safe persistence. This approach applies best practices for upserts, ensuring data is safely written to PostgreSQL or compatible engines.
Yes, you need SQLAlchemy to manage SQL tables in Python data pipelines, along with pandas. A database URL must also be provided via environment variables or the OpenHEXA SDK to establish the connection.
You can safely upsert data in PostgreSQL using Python by leveraging built-in operations that handle upserts automatically. This eliminates repetitive boilerplate and ensures data integrity when updating existing records.
Reading and writing SQL tables in notebook workflows works by executing SQL queries to load data into pandas DataFrames, transforming the data, and then writing results to target tables. This supports clean data workflows with minimal code.
To ensure a SQL table exists before writing a DataFrame in Python, use built-in operations designed to verify table existence. This allows safe persistence of DataFrames to database tables using explicit schema definitions.
GDSDNValidate database environment variables, SSL mode, pooler config, and PostgreSQL connectivity.
Interstellar-codeExecute SQL queries against MySQL and PostgreSQL databases from the command line.
SnakeORefactor Pandas row-wise operations into vectorized pipelines with PyArrow.
siondwRun SQL queries against Supabase tables to inspect contest and user data.
