Aegis DQ MCP server

Aegis DQ is a free tool that checks the quality of data in your database. It looks for problems like missing values, duplicates, or numbers that make no sense, then explains what likely caused each problem. It is handy for anyone who works with data and wants a second pair of eyes.

What this MCP server does

You ask your AI to check your data. The AI passes your request to this helper, which runs a set of rules against your database, such as checking for empty fields or values outside an allowed range. When a rule fails, the helper asks a language model to explain the likely cause. It also proposes a SQL statement that could fix the problem. Finally, it hands back a report with the results, the explanations, and the suggested fixes.

Click to zoom

What you can do with it

• Check your data for missing values, duplicates, and out-of-range numbers
• Get a plain-English explanation of why a data check failed
• See a suggested SQL fix for each problem found
• Generate a starter set of data rules from your table layout
• Run checks without an AI key if you only need pass or fail results
• Look back at past runs to see what the AI decided and why

Try asking your AI

• “Run the data quality rules on my orders table and tell me what failed.”
• “Why did the customer ID check fail, and what should I do about it?”
• “Generate some basic rules for my products table.”
• “Show me the suggested SQL to fix the negative price values.”

What it gives back to you

You get back a summary showing how many rules passed and failed, along with a pass rate. For each failure, you see a short explanation of the likely cause and a suggested SQL statement to fix it. The results appear right in your chat, and you can also save a full report as a file.

Before you start

Who it's for

Data analysts, data engineers, and anyone who works with databases and wants to catch data problems early.