JetBrains DataSpell

Turn data into insights with ease

DataSpell is an Integrated Development Environment (IDE) that is dedicated to specific tasks for exploratory data analysis and prototyping ML (machine learning) models.

A powerful toolkit for working with data

Interactive tables

Effortlessly view, navigate, sort, and filter data. Create charts and access essential data insights, including descriptive statistics and missing values – all without writing a single line of code. Unleash the power of data with AI Assistant to make the journey from data to insights even smoother. Work with tables in Jupyter notebooks using Python or SQL cells, in Python console, or within a separate window.

Smart Jupyter notebooks with integrated SQL support

Effortlessly work with both local and remote notebooks within DataSpell. Use SQL, Python, or no-code – all within a unified intelligent notebook. Navigate seamlessly with the Structure view, easily convert your notebooks to Python scripts with just a few clicks, use project templates with pre-installed libraries for faster setup, experience visually appealing graphs and visualizations that match your chosen color scheme, and more.

Best-in-class language support for Python

DataSpell enhances Python, the premier language for data work, with best-in-class support to ensure both speed and accuracy. Benefit from the smartest code completion, PEP 8 compliance checks, intelligent refactorings, and a variety of inspections to meet all your needs. With Python at its core, DataSpell empowers you to code with confidence and deliver high-quality results efficiently.

SQL

DataSpell delivers superior SQL support with advanced autocompletion and easy schema navigation, connecting you to over 40 SQL and NoSQL databases, including PostgreSQL and MySQL. Effortlessly query databases using SQL cells in Jupyter notebooks or in a dedicated console, and easily visualize, view, or change your data with or without code.

dbt Core

Effortlessly transform your data in DataSpell using dbt Core, a vital tool for data analytics engineers. Create dbt projects, and write, test, and deploy dbt models with ease. Enjoy smart completion for SQL and YML files, and see your changes with the help of a bundled database plugin right in your IDE.

Git support

Easily clone, commit, and push changes. Work with branches, manage changelists, and stage updates. Effortlessly merge files with a visual merge tool featuring side-by-side comparisons and highlighted changes.

R support

Enjoy intelligent coding assistance, dataset and visualization exploration, package management, and more.

Technologies you love supported

Experience first-class support for modern analytics libraries, tools, and technologies.

AI Assistant in DataSpell

Besides yourself, who knows your project best? Your IDE! And that’s why AI Assistant can be so context-aware and helpful. It helps you complete tasks even faster and be more productive.