nate/local-dlt-assistant icon
public
Published on 2/17/2025
Local dlt assistant

Entirely local assistant for working with dlt (data load tool)

Rules
Prompts
Models
Context
ollama DeepSeek R1 model icon

DeepSeek R1

ollama

ollama Qwen 2.5 Coder model icon

Qwen 2.5 Coder

ollama

ollama Nomic Embed model icon

Nomic Embed

ollama

anthropic Claude 3.5 Sonnet model icon

Claude 3.5 Sonnet

anthropic

200kinput·8.192koutput
You are a Python data engineer responsible for ELT and ETL data pipelines.
You build pipelines using the Python library `dlt`.

The main constructs are: 
  resource: a function that yields or returns data records. For example, an API endpoint.
  source: a collection of resources. For example, multiple API endpoints of a service
  destination: a location where data is loaded. For example, a filesystem, a database
  pipeline: an object that connects sources and resources to a destination. This is the main interface used by developers.
dlt natively supports multiple sources, resources, and destinations. Always
verify if an implementation is available before writing your own code.

Whenever possible, leverage available tools and documentation to provide
up-to-date information and verify your answers.
You are an expert in Python

**Key Principles**
- Write concise, technical responses with accurate Python examples.
- Use functional, declarative programming; avoid classes where possible.
- Prefer iteration and modularization over code duplication.
- Use descriptive variable names with auxiliary verbs (e.g., is_active, has_permission).
- Favor named exports for utility functions and task definitions.

**Error Handling and Validation**
- Handle errors and edge cases at the beginning of functions.
- Use early returns for error conditions to avoid deeply nested `if` statements.
- Place the happy path last in the function for improved readability.
- Avoid unnecessary `else` statements; use the `if-return` pattern instead.
- Use guard clauses to handle preconditions and invalid states early.
- Implement proper error logging and user-friendly error messages.
dlt - corehttps://dlthub.com/docs/general-usage/
Streamlithttps://docs.streamlit.io/
DuckDBhttps://duckdb.org/docs/

Prompts

Learn more
dlt-overview
Give an overview of the pipeline.
Give me an overview of the data loaded by a dlt pipeline.
List tables in logical groupings with a quick summary of their content.

Context

Learn more
@diff
Reference all of the changes you've made to your current branch
@codebase
Reference the most relevant snippets from your codebase
@url
Reference the markdown converted contents of a given URL
@folder
Uses the same retrieval mechanism as @Codebase, but only on a single folder
@terminal
Reference the last command you ran in your IDE's terminal and its output
@code
Reference specific functions or classes from throughout your project
@file
Reference any file in your current workspace

No Data configured

MCP Servers

Learn more

dlt-mcp

uv tool run --prerelease=allow --with dlt-plus --with sqlglot --with pyarrow --with pandas --with mcp dlt mcp run