Skip to main content

directly import and convert their relational data into a Featuretools

Project description

Automated creation of EntitySets from relational data stored in SQL databases

PyPI Version Documentation Status Anaconda Version StackOverflow PyPI Downloads

The featuretools_sql library allows you to directly import your relational data into Featuretools to run automated feature engineering.


Install with pip:

python -m pip install "featuretools[sql]"

or from the Conda-forge channel on conda:

conda install -c conda-forge featuretools


Simply pass in the database connection information:

from featuretools_sql.connector import DBConnector

sql_connector = DBConnector(
    system_name = "mysql",
    host = ""
    user = "root",
    password = "password",
    database = "db"
entityset = sql_connector.get_entityset()

The entityset object will have the relationships and DataFrames already populated, allowing you to call featuretools.DFS and run automated feature generation.

import featuretools as ft

feature_defs, feature_matrix = ft.dfs(

We currently supports importing data from the following relational database systems:

  • MySQL
  • PostgreSQL
  • Snowflake


The Featuretools community is happy to provide support to users. Project support can be found in four places depending on the type of question:

  1. For usage questions, use Stack Overflow with the featuretools tag.
  2. For bugs, issues, or feature requests start a Github issue.
  3. For discussion regarding development, use Slack.
  4. For everything else, the core developers can be reached by email at

Built at Alteryx

featuretools_sql is an open source project maintained by Alteryx. To see the other open source projects we’re working on, visit Alteryx Open Source. If building impactful data science pipelines is important to you or your business, please get in touch.

Alteryx Open Source

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

featuretools_sql-0.0.5.tar.gz (10.1 kB view hashes)

Uploaded Source

Built Distribution

featuretools_sql-0.0.5-py3-none-any.whl (14.0 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page