What is the AACT database?

The AACT database is the Aggregate Analysis of ClinicalTrials.gov database, containing a wealth of information on clinical trials conducted worldwide. Ctgov allows you to directly query and analyze this data.

What can I do with Ctgov?

You can use Ctgov to analyze clinical trial patterns for specific therapeutic areas, track development trends, generate analysis memos summarizing key insights, and execute custom SELECT queries on the AACT database.

What credentials does it need?

It reads `DB_USER`, `DB_PASSWORD` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Ctgov MCP Server

Enables analysis of clinical trial data from the AACT database, tracking development trends, and generating analysis memos.

Local serverstdio★ 9

What is the Ctgov MCP Server?

Enables analysis of clinical trial data from the AACT database, tracking development trends, and generating analysis memos.

What it actually does

Query the AACT (ClinicalTrials.gov) database directly from Claude. Explore 70+ tables of clinical trial data — studies, interventions, outcomes, sponsors, facilities — using read-only SQL with buffered pagination.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
database_info	Confirm database connection, server time, and data currency
list_tables	Discover all available tables with approximate row counts
describe_table	Inspect column names, types, distinct counts, and sample values
get_column_values	Get distinct values for a column with counts — essential before filtering
search_columns	Find columns by keyword across all tables (e.g. masking -> designs.masking)
read_query	Execute a SELECT, CTE, or EXPLAIN query with buffered results and preview
fetch_rows	Page through buffered query results without re-querying

How to install the Ctgov MCP Server

{
  "mcpServers": {
    "aact": {
      "command": "uvx",
      "args": ["mcp-server-aact"],
      "env": {
        "DB_USER": "your_username",
        "DB_PASSWORD": "your_password"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

Variable	Description	Required
DB_USER	Configuration value read at startup.	Optional
DB_PASSWORD	Configuration value read at startup.	Optional

Example prompts to try

“Use Ctgov to database info.”
“Use Ctgov to list tables.”
“Use Ctgov to describe table.”

Frequently asked questions

Ctgov is a tool that provides access to and enables analysis of clinical trial data from the AACT (Aggregate Analysis of ClinicalTrials.gov) database. It helps track development trends in therapeutic areas and automatically generates analysis memos.