mapj-protheus-query

You can run read-only SQL queries against a Protheus ERP database by using the mapj CLI, which enforces strict prefix-based validation to block DML/DDL operations and returns structured JSON or Toon outputs for automation.

Yes, you can query Protheus data across multiple environments by using named connection profiles, which allow you to target different databases directly without altering your active session configuration.

You can store and reuse parameterized SQL queries for Protheus data extraction by utilizing the presets system, enabling repeatable tasks without rewriting SQL statements for each execution.

Yes, mapj supports optional schema discovery to inspect Protheus table structures before querying, ensuring accurate results by validating table and column names against the live database schema.

When extracting Protheus ERP data, the available output formats are JSON and Toon. These automation-friendly formats provide structured outputs that integrate seamlessly with agent workflows and downstream systems.

The limitation of prefix-based validation is that it strictly blocks any SQL statements not matching allowed read-only prefixes, preventing all DML and DDL operations to ensure data safety but restricting queries to read-only commands.