Can Gemini Search the ChEMBL Database?
Published:
Introduction
I’ve been an enthusiastic user of the ChEMBL database for more than a decade. ChEMBL contains a treasure trove of information curated from medicinal chemistry journals. When I’m building an initial machine learning model or analyzing the SAR around a particular target, ChEMBL is the first place I go. I’m reasonably good at SQL, but I still spend a lot of time figuring out which data is in which tables and how to join them correctly to get the information I need. For years, I’ve longed for a more straightforward way to query ChEMBL. I recently discovered that the Gemini CLI from Google can write SQL queries for ChEMBL and extract the information I need into a CSV file. Is this my dream come true? Can I stop spending time staring at the ChEMBL schema and just pose a simple natural-language query like this?
> get the smiles,chembl_id, target_name, publication year, article doi,
and IC50 for all kinase inhibitors published after 2022
and write this into a file called kinase_inhibitors_after_2022.csv

This is the new home of the Practical Cheminformatics blog. 80 previous posts are still avilable at