Explore a database schema
Prompt
Use a schema-first, read-only workflow before asking an AI assistant to query data.
Project links
How to use it
- Copy the prompt and replace bracketed details with your own context.
- Use the related resource links to configure any required tools in your own environment.
- Run the prompt in your assistant and review its output against the source material.
The prompt
Using Strata MCP, inspect the database connection I select. List the tables, then describe the tables relevant to [my question]. Do not assume column meanings. Ask me to confirm ambiguous date, amount, and identifier fields. Propose a bounded read-only query and explain what it will return before running it. Do not modify tables or records.
Example results
Illustrative example
Example response structure Relevant tables: list the tables inspected. Field meanings: identify what is known and what needs confirmation. Proposed query: show a bounded read-only statement. Interpretation: explain the expected columns and the limits of the result.
Illustrative response outline, not a recorded run.
Illustrative examples show a possible response format. They are not recorded runs or verified results. Actual responses will vary.