chembl-database

Retrieve filtered bioactive compound and target data from the ChEMBL database.

783|65|Updated Feb 27, 2026
One-click install
npx skills add https://github.com/LeonChaoX/qinyan-academic-skills --skill chembl-database-leonchaox
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: chembl-database
Source: https://github.com/LeonChaoX/qinyan-academic-skills/tree/main/skills/12-%E7%A7%91%E5%AD%A6%E6%95%B0%E6%8D%AE%E5%BA%93/chembl-database
Command: npx skills add https://github.com/LeonChaoX/qinyan-academic-skills --skill chembl-database-leonchaox

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill solves the problem of quickly finding bioactive compounds and retrieving drug-discovery bioactivity evidence from ChEMBL without writing complex database queries from scratch.

Core Features & Use Cases

  • Compound & target lookup: Retrieve molecule, target, and drug records by ChEMBL IDs and keyword searches.
  • Bioactivity data retrieval: Filter activities by standard type (e.g., IC50, Ki), numeric thresholds, and units (e.g., nM, uM).
  • Structure-based exploration: Run similarity searches and substructure matching using SMILES to support SAR-style workflows.
  • Model-ready exports: Convert results into pandas DataFrames for downstream analysis and reporting.

Quick Start

Ask the AI to retrieve EGFR IC50 inhibitors with standard_value <= 100 nM from ChEMBL and return the top compounds with their molecule and activity details.

Frequently Asked Questions about chembl-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I retrieve ChEMBL bioactivity data for specific drug targets?

To retrieve ChEMBL bioactivity data, filter activities by standard types like IC50 or Ki, apply numeric thresholds in nM or uM, and return molecule and target records using cached queries.

Can I search ChEMBL compounds by SMILES structure for SAR analysis?

Yes, you can search ChEMBL compounds by SMILES structure. The tool runs similarity searches and substructure matching to support structure-based exploration and SAR-oriented workflows.

What is the best way to find IC50 inhibitors in ChEMBL under a specific concentration?

The best way to find IC50 inhibitors in ChEMBL is to query activity records filtered by standard_value thresholds, such as less than 100 nM, and retrieve the matching molecule details.

Do I need the chembl_webresource_client Python package to query ChEMBL data?

Yes, you need the chembl_webresource_client Python client to query ChEMBL data. The Skill requires this dependency to provide filtered molecule, target, and mechanism datasets with lazy evaluation.

How do I export ChEMBL molecule and target records into a pandas DataFrame?

To export ChEMBL molecule and target records into a pandas DataFrame, execute filtered queries through the Python client and convert the retrieved model-ready datasets for downstream analysis.

What limitations exist when filtering ChEMBL bioactivity data by standard type?

When filtering ChEMBL bioactivity data by standard type, limitations include relying on standardized activity records and requiring valid numeric thresholds with compatible units like nM or uM.