Query an employee sample database for common SQL analytics and insights.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "test-emp-database-mcp" yet — see the docs or source repo.
Use this MCP tool to query the employee database and list the top 5 highest-paid employees, returning name, department, title, and salary sorted by salary descending.
A ranked list of the top 5 earners with name, department, title, and salary.
Using the sample employee data, calculate each department's average salary, employee count, and maximum salary, then identify the department with the highest average salary.
A department-level salary summary plus the department with the highest average salary.
Please use window functions to rank employee salaries within each department, returning each employee's name, department, salary, and salary rank inside the department.
An employee list with within-department salary ranks for compensation comparison.
Interact with SQLite via MCP for CRUD, SQL queries, and schema exploration.
Query employee data through MCP tools and demonstrate Pega AI agent integration.
Safely query a read-only SQLite database for structured data insights.
Connect to major databases via MCP to run SQL queries and commands.
Inspect database schemas, index issues, table bloat, and query plans.
Securely inspect and query SQL Server databases for analysis and troubleshooting.