Creating APIs That Data Scientists Will Love with FastAPI, SQLAlchemy, and Pydantic


Data scientists and machine learning engineers are an important and growing API user base. But they’re not just another set of software developers – they have unique goals and tools. Ryan will share practical tips for making APIs that data scientists will love.

Ryan will give a tour of the primary tasks that data scientists perform in their daily work and the tools in the Python ecosystem that they use such as Jupyter notebooks, Airflow, FastAPI, and Streamlit. Then he will discuss how those tools interact with APIs.

The primary focus of the session will be demonstrating how to implement a data scientist-friendly API. The demonstrated APIs will use Python frameworks FastAPI for the API control, SQLAlchemy for data access, and Pydantic for data validation. In addition to the APIs, the session will demonstrate the value of Software Development Kits (SDKs) for data scientist usage. Attendees will learn to create APIs and SDKs using the demonstrated technologies.

Session Outline:

Tips for creating APIs that Data Scientist will love.
Creating a basic API using FastAPI - FastAPI
Adding data access using SQLAlchemy - SQLAlchemy, SQLite
Adding data validation using Pydantic - Pydantic, OpenAPI
Creating an SDK to make usage easier for API

Background Knowledge:

Background knowledge of Python.
Familiarity with command line interface.
General understanding of REST APIs.


Ryan Day is an advanced data scientist at the Conference of State Bank Supervisors (CSBS), a non-profit association in the financial services industry. At CSBS, Ryan supports state regulators by performing cloud software architecture, economics modeling, and advancing a data strategy. He is an AWS certified solutions architect and member of the National Association of Business Economics. He previously led the digital services division for a Federal agency, where he helped developers learn cloud development and adopt API standards. Ryan is an experienced open-source developer who participates in the FastAPI project.

Ryan is currently writing a book titled ""Hands-On APIs for AI and Data Science"". It will be published in May 2025 by O'Reilly Publishing.

Open Data Science




Open Data Science
One Broadway
Cambridge, MA 02142

Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Consent to display content from - Youtube
Consent to display content from - Vimeo
Google Maps
Consent to display content from - Google