← MCP Security Catalog

dlt 0.3.0

pypi · dlt-mcp · latest release

Scan failed
Security result
8
Observed tools
Version rating
Change risk

Independent inventory

Observed 2026-08-23T19:03:27.959Z using mcpSecurity-inventory. Protocol 2025-06-18.

ToolCategoryRisk
display_schemaGenerate a mermaid diagram to represent the pipeline schema pipeline_name: name of the pipeline hide_columns: when True, the columns are hidden
Input schema
{
  "additionalProperties": false,
  "properties": {
    "pipeline_name": {
      "type": "string"
    },
    "hide_columns": {
      "default": false,
      "type": "boolean"
    }
  },
  "required": [
    "pipeline_name"
  ],
  "type": "object"
}
Output schema
{
  "properties": {
    "result": {
      "type": "string"
    }
  },
  "required": [
    "result"
  ],
  "type": "object",
  "x-fastmcp-wrap-result": true
}
execute_sql_query
Input schema
{
  "additionalProperties": false,
  "properties": {
    "pipeline_name": {
      "type": "string"
    },
    "sql_select_query": {
      "type": "string"
    }
  },
  "required": [
    "pipeline_name",
    "sql_select_query"
  ],
  "type": "object"
}
Output schema
{
  "properties": {
    "result": {
      "items": {
        "items": {},
        "type": "array"
      },
      "type": "array"
    }
  },
  "required": [
    "result"
  ],
  "type": "object",
  "x-fastmcp-wrap-result": true
}
get_load_tableRetrieve metadata about data loaded with dlt.
Input schema
{
  "additionalProperties": false,
  "properties": {
    "pipeline_name": {
      "type": "string"
    }
  },
  "required": [
    "pipeline_name"
  ],
  "type": "object"
}
Output schema
{
  "properties": {
    "result": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "type": "array"
    }
  },
  "required": [
    "result"
  ],
  "type": "object",
  "x-fastmcp-wrap-result": true
}
get_pipeline_local_stateRetrieve the pipeline state information. Includes: incremental dates, resource state, source state
Input schema
{
  "additionalProperties": false,
  "properties": {
    "pipeline_name": {
      "type": "string"
    }
  },
  "required": [
    "pipeline_name"
  ],
  "type": "object"
}
Output schema
{
  "description": "Schema for a pipeline state that is stored within the pipeline working directory",
  "properties": {
    "_state_version": {
      "type": "integer"
    },
    "_version_hash": {
      "type": "string"
    },
    "_state_engine_version": {
      "type": "integer"
    },
    "pipeline_name": {
      "type": "string"
    },
    "dataset_name": {
      "type": "string"
    },
    "default_schema_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "schema_names": {
      "anyOf": [
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ]
    },
    "destination_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "destination_type": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "staging_name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "staging_type": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "_local": {
      "properties": {
        "first_run": {
          "type": "boolean"
        },
        "_last_extracted_at": {
          "format": "date-time",
          "type": "string"
        },
        "_last_extracted_hash": {
          "type": "string"
        },
        "initial_cwd": {
          "type": "string"
        },
        "last_run_context": {
          "anyOf": [
            {
              "description": "Stores context from the last successful pipeline run or sync",
              "properties": {
                "run_dir": {
                  "type": "string"
                },
                "uri": {
                  "type": "string"
                },
                "local_dir": {
                  "type": "string"
                },
                "settings_dir": {
                  "type": "string"
                }
              },
              "type": "object"
            },
            {
              "type": "null"
            }
          ]
        },
        "_dev_mode": {
          "type": "boolean"
        }
      },
      "type": "object"
    },
    "sources": {
      "additionalProperties": {
        "additionalProperties": true,
        "type": "object"
      },
      "type": "object"
    }
  },
  "type": "object"
}
get_table_schemaGet the schema of the specified table.
Input schema
{
  "additionalProperties": false,
  "properties": {
    "pipeline_name": {
      "type": "string"
    },
    "table_name": {
      "type": "string"
    }
  },
  "required": [
    "pipeline_name",
    "table_name"
  ],
  "type": "object"
}
Output schema
{
  "description": "TypedDict that defines properties of a table",
  "properties": {
    "x-normalizer": {
      "anyOf": [
        {
          "additionalProperties": true,
          "type": "object"
        },
        {
          "type": "null"
        }
      ]
    },
    "x-loader": {
      "anyOf": [
        {
          "additionalProperties": true,
          "type": "object"
        },
        {
          "type": "null"
        }
      ]
    },
    "x-extractor": {
      "anyOf": [
        {
          "additionalProperties": true,
          "type": "object"
        },
        {
          "type": "null"
        }
      ]
    },
    "name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "description": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "schema_contract": {
      "anyOf": [
        {
          "enum": [
            "evolve",
            "discard_value",
            "freeze",
            "discard_row"
          ],
          "type": "string"
        },
        {
          "description": "TypedDict defining the schema update settings",
          "properties": {
            "tables": {
              "anyOf": [
                {
                  "enum": [
                    "evolve",
                    "discard_value",
                    "freeze",
                    "discard_row"
                  ],
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ]
            },
            "columns": {
              "anyOf": [
                {
                  "enum": [
                    "evolve",
                    "discard_value",
                    "freeze",
                    "discard_row"
                  ],
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ]
            },
            "data_type": {
              "anyOf": [
                {
                  "enum": [
                    "evolve",
                    "discard_value",
                    "freeze",
                    "discard_row"
                  ],
                  "type": "string"
                },
                {
                  "type": "null"
                }
              ]
            }
          },
          "type": "object"
        },
        {
          "type": "null"
        }
      ]
    },
    "table_sealed": {
      "anyOf": [
        {
          "type": "boolean"
        },
        {
          "type": "null"
        }
      ]
    },
    "parent": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "filters": {
      "anyOf": [
        {
          "properties": {
            "excludes": {
              "anyOf": [
                {
                  "items": {
                    "type": "string"
                  },
                  "type": "array"
                },
                {
                  "type": "null"
                }
              ]
            },
            "includes": {
              "anyOf": [
                {
                  "items": {
                    "type": "string"
                  },
                  "type": "array"
                },
                {
                  "type": "null"
                }
              ]
            }
          },
          "required": [
            "excludes",
            "includes"
          ],
          "type": "object"
        },
        {
          "type": "null"
        }
      ]
    },
    "columns": {
      "additionalProperties": {
        "description": "TypedDict that defines additional column hints",
        "properties": {
          "data_type": {
            "anyOf": [
              {
                "enum": [
                  "text",
                  "double",
                  "bool",
                  "timestamp",
                  "bigint",
                  "binary",
                  "json",
                  "decimal",
                  "wei",
                  "date",
                  "time"
                ],
                "type": "string"
              },
              {
                "type": "null"
              }
            ]
          },
          "nullable": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "precision": {
            "anyOf": [
              {
                "type": "integer"
              },
              {
                "type": "null"
              }
            ]
          },
          "scale": {
            "anyOf": [
              {
                "type": "integer"
              },
              {
                "type": "null"
              }
            ]
          },
          "timezone": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "x-normalizer": {
            "anyOf": [
              {
                "additionalProperties": true,
                "type": "object"
              },
              {
                "type": "null"
              }
            ]
          },
          "name": {
            "anyOf": [
              {
                "type": "string"
              },
              {
                "type": "null"
              }
            ]
          },
          "description": {
            "anyOf": [
              {
                "type": "string"
              },
              {
                "type": "null"
              }
            ]
          },
          "partition": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "cluster": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "unique": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "sort": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "primary_key": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "row_key": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "parent_key": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "root_key": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "merge_key": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "variant": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "hard_delete": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          },
          "dedup_sort": {
            "anyOf": [
              {
                "enum": [
                  "asc",
                  "desc"
                ],
                "type": "string"
              },
              {
                "type": "null"
              }
            ]
          },
          "incremental": {
            "anyOf": [
              {
                "type": "boolean"
              },
              {
                "type": "null"
              }
            ]
          }
        },
        "type": "object"
      },
      "type": "object"
    },
    "resource": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "table_format": {
      "anyOf": [
        {
          "enum": [
            "iceberg",
            "delta",
            "hive",
            "native"
          ],
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "file_format": {
      "anyOf": [
        {
          "enum": [
            "preferred",
            "jsonl",
            "typed-jsonl",
            "insert_values",
            "parquet",
            "csv",
            "reference",
            "model"
          ],
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "variant_name": {
      "type": "string"
    },
    "write_disposition": {
      "anyOf": [
        {
          "enum": [
            "skip",
            "append",
            "replace",
            "merge"
          ],
          "type": "string"
        },
        {
          "type": "null"
        }
      ]
    },
    "references": {
      "anyOf": [
        {
          "items": {
            "properties": {
              "label": {
                "anyOf": [
                  {
                    "type": "string"
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "cardinality": {
                "anyOf": [
                  {
                    "enum": [
                      "zero_to_one",
                      "one_to_zero",
                      "zero_to_many",
                      "many_to_zero",
                      "one_to_many",
                      "many_to_one",
                      "one_to_one",
                      "many_to_many"
                    ],
                    "type": "string"
                  },
                  {
                    "type": "null"
                  }
                ]
              },
              "columns": {
                "items": {
                  "type": "string"
                },
                "type": "array"
              },
              "referenced_table": {
                "type": "string"
              },
              "referenced_columns": {
                "items": {
                  "type": "string"
                },
                "type": "array"
              },
              "table": {
                "anyOf": [
                  {
                    "type": "string"
                  },
                  {
                    "type": "null"
                  }
                ]
              }
            },
            "type": "object"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ]
    }
  },
  "type": "object"
}
get_table_schema_diffGet the diff between schema versions of a table.
Input schema
{
  "additionalProperties": false,
  "properties": {
    "pipeline_name": {
      "type": "string"
    },
    "table_name": {
      "type": "string"
    },
    "another_version_hash": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null
    }
  },
  "required": [
    "pipeline_name",
    "table_name"
  ],
  "type": "object"
}
Output schema
{
  "properties": {
    "result": {
      "type": "string"
    }
  },
  "required": [
    "result"
  ],
  "type": "object",
  "x-fastmcp-wrap-result": true
}
list_pipelinesList all available dlt pipelines. Each pipeline has several tables.
Input schema
{
  "additionalProperties": false,
  "properties": {},
  "type": "object"
}
Output schema
{
  "properties": {
    "result": {
      "items": {
        "type": "string"
      },
      "type": "array"
    }
  },
  "required": [
    "result"
  ],
  "type": "object",
  "x-fastmcp-wrap-result": true
}
list_tablesList all available tables in the specified pipeline.
Input schema
{
  "additionalProperties": false,
  "properties": {
    "pipeline_name": {
      "type": "string"
    }
  },
  "required": [
    "pipeline_name"
  ],
  "type": "object"
}
Output schema
{
  "properties": {
    "result": {
      "items": {
        "type": "string"
      },
      "type": "array"
    }
  },
  "required": [
    "result"
  ],
  "type": "object",
  "x-fastmcp-wrap-result": true
}

Resources 0

Resource templates 0

Prompts 1

Changes from previous version

No completed comparison is available.

RiskChangeSubject
No material changes recorded.

Confirmed vulnerabilities

SeverityFindingAdvisory
No confirmed vulnerability is published for this version.

Provenance

Artifact SHA-256: d3e2fabd2db0f4426f925bcfdc4626872e9914bb0cef57062790ddeda1f8ef76

Scanner: mcp-proof-engine 0.1.0.

Let’s talk about MCP security.

Share your details and our security team will contact you.