A PostgreSQL-based memory and financial management system for AI agents. Implements a 4-layer memory architecture (short-term in n8n, structured facts in PostgreSQL, documentary in Markdown, audited in logs) and a comprehensive financial core with deduplication, full-text search, invariant enforcement via triggers, and role-based access control.
This is a SQL schema definition file, not an MCP server. The 'tools' are PostgreSQL functions and triggers, not MCP tool definitions. No tool registration, no JSON schemas, no descriptions suitable for LLM consumption, and no MCP protocol implementation detected. The source is educational SQL documentation with comments, not a functional MCP server. All tools lack proper MCP-style schemas and descriptions optimized for agent reasoning.
Forma canónica de un texto: minúsculas, sin acentos, sin puntuación y con espacios colapsados. Es la base de la deduplicación y de la búsqueda.
Trigger genérico: mantiene updated_at sin depender de que la aplicación se acuerde.
Invariante v4.5: un pago está en la misma moneda que su deuda y que su movimiento de respaldo, y nunca excede el saldo pendiente.
Cotización vigente a una fecha (la última con fecha <= p_fecha). Devuelve cero filas si no hay dato: ausencia de cotización es ausencia de fila, nunca un cero.
Invariante: nada se borra físicamente. Se aplica a todas las tablas con valor histórico o probatorio.
Trigger genérico: mantiene updated_at sin depender de que la aplicación se acuerde.
No MCP tool registration detected. Source is raw SQL schema, not an MCP server implementation. Tools are PostgreSQL functions, not MCP-callable tools with JSON schemas.
No input schemas in JSON Schema format. Parameter descriptions exist in SQL comments but are not machine-parseable or LLM-optimized. Schemas must declare types, constraints, and enums.
Tool names do not follow verb_noun convention. 'tocar_updated_at' and 'prohibir_delete_fisico' are opaque to LLMs. Should be 'update_timestamp' and 'prevent_physical_delete' or similar action-oriented names.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | F | 15 | 2026-07-28+ | v2 |
No output schemas documented. LLMs cannot infer what fields are returned or plan downstream tool calls. fx_vigente returns rows but structure is not declared.
Trigger functions (tocar_updated_at, prohibir_delete_fisico, deuda_pago_validar) are database constraints, not user-callable tools. They should not be exposed as MCP tools, they execute automatically on table events.