An MCP server for connecting to PostgreSQL databases, indexing schemas semantically via ChromaDB, and executing SQL queries with natural language search capabilities.
SmartGIU defines 4 tools with complete Zod schemas and descriptions in Portuguese. All tools have input schemas with type definitions and parameter descriptions. However, descriptions lack LLM-optimized guidance on when/why to use each tool, and output schemas are not documented. Tool naming follows verb_noun convention (conectar, buscar, executar, listar) but descriptions are verbose (200+ chars) and include implementation details (ChromaDB indexing) rather than user-facing intent. No error handling guidance, no pagination support for potentially large result sets, and no documented output structure for agents to plan downstream calls.
Faz uma busca semântica no schema indexado do banco de dados. Retorna as tabelas e colunas mais relevantes para a consulta em linguagem natural. Use antes de executar_query para entender a estrutura correta.
Conecta a um banco de dados PostgreSQL (local ou remoto) usando as credenciais fornecidas. Lê o schema completo (tabelas, colunas, relações FK) e indexa no ChromaDB para buscas semânticas. Execute esta ferramenta primeiro, antes de qualquer outra.
Executa uma query SQL diretamente no banco de dados conectado e retorna os resultados formatados. Use buscar_informacoes antes para garantir que o SQL está correto.
Retorna o schema completo do banco de dados conectado: todas as tabelas, colunas com tipos, constraints e relações de chave estrangeira. Útil para validar a estrutura antes de escrever queries.
Output schemas not documented. Agents cannot plan downstream tool calls or extract required fields (e.g., table names from buscar_informacoes, result structure from executar_query). LLMs must guess output format.
No error handling guidance. If conectar_banco fails (invalid credentials, network error, ChromaDB unavailable), the response provides no recovery path. Agents cannot self-correct or suggest alternatives.
Descriptions include implementation details (ChromaDB, semantic indexing) rather than user-facing intent. 'Lê o schema completo...e indexa no ChromaDB' is 80+ chars of internal mechanism; should focus on 'Connects to PostgreSQL and prepares schema for queries.'
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | D | 59 | 2026-07-28+ | v2 |
No pagination or result limits documented. executar_query and listar_schema could return thousands of rows/columns. No mention of max results, offset/limit params, or guidance on handling large schemas.
Credentials (usuario, senha) exposed as tool parameters. Agent traces log all parameters, secrets leak into logs and prompt history. Should use server-side secret injection via environment variables.