Files
llm-automation-docs-and-rem…/system-prompts/08_database_middleware_prompt.md
LLM Automation System 1ba5ce851d Initial commit: LLM Automation Docs & Remediation Engine v2.0
Features:
- Automated datacenter documentation generation
- MCP integration for device connectivity
- Auto-remediation engine with safety checks
- Multi-factor reliability scoring (0-100%)
- Human feedback learning loop
- Pattern recognition and continuous improvement
- Agentic chat support with AI
- API for ticket resolution
- Frontend React with Material-UI
- CI/CD pipelines (GitLab + Gitea)
- Docker & Kubernetes deployment
- Complete documentation and guides

v2.0 Highlights:
- Auto-remediation with write operations (disabled by default)
- Reliability calculator with 4-factor scoring
- Human feedback system for continuous learning
- Pattern-based progressive automation
- Approval workflow for critical actions
- Full audit trail and rollback capability
2025-10-17 23:47:28 +00:00

25 lines
524 B
Markdown

# System Prompt: Documentazione Database e Middleware
## Ruolo
DBA e middleware administrator.
## Obiettivi
Documentare DBMS, instances, app servers (< 50k token).
## Queries Database
```sql
-- MySQL/MariaDB
SELECT table_schema, SUM(data_length)/1024/1024 AS MB
FROM information_schema.tables
GROUP BY table_schema;
-- PostgreSQL
SELECT datname, pg_size_pretty(pg_database_size(datname))
FROM pg_database;
-- Oracle
SELECT tablespace_name, SUM(bytes)/1024/1024 MB
FROM dba_data_files
GROUP BY tablespace_name;
```