skills.rest
Nelkit
NelkitCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

ingest-script

Generate Python ingestion scripts for PostgreSQL tables with upsert behavior.

1|Updated Mar 28, 2026
Search Tags:#script generation#PostgreSQL#data ingestion#SQLAlchemy#Python
One-click install
npx skills add https://github.com/Nelkit/sydney-liveability-ai --skill ingest-script
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ingest-script
Source: https://github.com/Nelkit/sydney-liveability-ai/tree/main/.copilot/skills/ingest-script
Command: npx skills add https://github.com/Nelkit/sydney-liveability-ai --skill ingest-script

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires FastAPI, SQLAlchemy, Alembic, Supabase, and includes scripts (resource) components.

What problem does it solve?

This Skill automates the creation of Python ingestion scripts for PostgreSQL tables, ensuring consistency and reducing manual effort in data pipeline development.

Core Features & Use Cases

  • Script Generation: Automatically generates Python scripts for data ingestion.
  • Upsert Behavior: Ensures safe upserts into PostgreSQL tables.
  • Metadata Management: Assigns clear ownership and versioning to scripts.
  • Use Case: When developing new ingestion scripts for data pipelines in the Sydney Liveability Explorer backend, this Skill streamlines the process.

Quick Start

Use the ingest-script skill to create an ingestion script for the 'transport' table.

Frequently Asked Questions about ingest-script

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Python script generation for PostgreSQL data ingestion?▼

Automate PostgreSQL data ingestion script generation by using this Skill to create consistent Python scripts that handle safe upserts, metadata management, and versioning for data pipelines.

Do I need pre-existing SQLAlchemy model definitions to generate ingestion scripts?▼

Yes, you need pre-existing SQLAlchemy model definitions and session management setup before generating ingestion scripts, as the Skill relies on these to automate safe upserts into PostgreSQL tables.

Can I use this Skill to generate upsert scripts for a Supabase PostgreSQL backend?▼

Yes, you can generate upsert scripts for a Supabase PostgreSQL backend, as the Skill is specifically designed to utilize Supabase and SQLAlchemy for automating safe data ingestion pipelines.

What is the best way to manage data ingestion pipelines for the Sydney Liveability Explorer?▼

The best way to manage data ingestion pipelines is using this Skill to automatically generate Python ingestion scripts with clear ownership, versioning, and upsert behavior tailored for the Sydney Liveability Explorer backend.

Does this data ingestion script generator support FastAPI and Alembic?▼

Yes, the data ingestion script generator supports FastAPI and Alembic, integrating these dependencies alongside SQLAlchemy and Supabase to maintain database migrations and API structures within the pipeline.

Related Skills

Explore More Software Engineering Skills→
boludo00boludo00
80

sqlalchemy

Manage PostgreSQL database interactions with SQLAlchemy 2.x ORM models and queries.

Community
Advanced
constructive-ioconstructive-io
52

orm-public

Perform type-safe CRUD operations on 103 PostgreSQL tables via GraphQL.

Official
Intermediate
sswapnil2sswapnil2

add-endpoint-python

Scaffold FastAPI endpoints with routers, services, repositories, and models.

Community
Intermediate
martinffxmartinffx
39

python:sqlalchemy

Provide SQLAlchemy 2.0+ ORM patterns for Python database access.

Community
Advanced