DataPyn
Download
Features Pynia Databases Docs Download
Desktop IDE · SQL + Python

One workspace for queries, pipelines, and analysis.

DataPyn is built for analysts and data engineers who work directly against databases: block-based SQL and Python, Monaco editing with schema intelligence, and Pynia for LLM-assisted development.

Get started Documentation
Windows Offline SQL intelligence Open source

Built for real data work

From ad-hoc SQL to reproducible Python — without leaving the editor.

SQL + Python blocks

Mix queries and scripts in one session. Run blocks independently and keep context between steps.

Schema-aware editing

Autocomplete, validation, and cross-database references — even offline.

Many databases

SQL Server, PostgreSQL, MySQL, Oracle, SQLite, Snowflake, BigQuery, and more.

Sessions & projects

Organize work by connection and file. Pick up where you left off.

Monaco editor

Familiar editing with themes, minimap, and inline completions tuned for SQL and Python.

Export & share

Notebook-style flows and outputs you can reuse in reports and pipelines.

Pynia

LLM assistance with full session context

Pynia is integrated into the IDE: it reads the active connection, schema, blocks, and selection, then can author SQL/Python and run blocks via tool calls.

  • Multi-provider GitHub Copilot, OpenAI, Anthropic, OpenRouter, and compatible endpoints.
  • Context-aware Uses the active connection, schema, and editor selection when you ask.
  • SQL + Python Suggests queries, refactors blocks, and helps with pandas-style follow-ups.

Some providers require their own subscription or API keys. Configure them in DataPyn settings.

Pynia

Supported connectors

GitHub Copilot OpenAI Anthropic OpenRouter Compatible APIs
Pynia · Settings → AI
ProviderOpenAI
Modelgpt-4o
ContextSchema + selection

Connect to your stack

Native drivers and familiar connection dialogs.

SQL Server
PostgreSQL
MySQL
MariaDB
SQLite
Databricks

Quick start

Install, connect, and run your first block in minutes.

1
Download DataPyn

Download DataPyn-Setup.exe from GitHub Releases.

2
Add a connection

Open Connections and register your database.

3
Enable Pynia (optional)

Sign in to Copilot or add API keys in Settings → AI.

4
Run SQL and Python

Create blocks, execute with Ctrl+Enter, and use Pynia from the chat panel.

git clone https://github.com/natharuc/datapyn.git
cd datapyn

Documentation

Guides for connections, sessions, Pynia, and advanced SQL.

All docs

docs.html

Connections

#first-connection

Pynia

#pynia

SQL editor

#code-blocks

Ready to work smarter with your data?

Download DataPyn, connect your databases, and meet Pynia in the chat panel.

Download for Windows