virtuoso-support-agent_skill

Overview

This skill provides technical support and database management for OpenLink Virtuoso Server, focused on RDF Views generation, SPARQL/SQL/GraphQL query help, and full lifecycle operations for knowledge graphs. It guides installation, configuration, troubleshooting, performance tuning, security, and automated RDF Views and ontology generation from relational tables. The skill includes 23 specialized tools and a strict workflow for safe, auditable RDF Views deployment.

How this skill works

It starts by confirming which Virtuoso instance to target (Demo or URIBurner) and then exposes the appropriate server-prefixed tools for discovery, generation, queries, audits, and utilities. For RDF Views, it follows a nine-step workflow: discover tables, get approval, assign IRIs, run pre-audit, generate views/ontology/data rules, execute scripts, run post-audit, and validate the knowledge graph. Query templates and execution tools support SPARQL, SQL, and GraphQL operations with automated audits and backups.

When to use it

• You need RDF Views generated from relational tables and an ontology produced automatically.
• Troubleshooting Virtuoso configuration, startup, or runtime errors.
• Designing and validating SPARQL queries, SQL diagnostics, or GraphQL endpoints.
• Performing metadata audits, backups, or post-deployment validation of a knowledge graph.
• Optimizing Virtuoso performance, security settings, or access control policies.

Best practices

• Always confirm and remember the target instance (Demo or URIBurner) before any operation.
• Obtain explicit user approval for table lists and Graph IRIs prior to generating views or scripts.
• Run metadata audits both before and after RDF Views generation and never modify generated SQL scripts.
• Use qualified table names for discovery (e.g., sqlserver.northwind.Customers) and keep remote DSN checks as error-recovery only.
• Use server-prefixed tool names (format: ServerName:ToolName) and the provided 30,000 ms timeout for predefined queries.

Example use cases

• Generate RDF Views, ontology, and Linked Data access rules for a Northwind schema and validate with SPARQL samples.
• Recover from a failed table-discovery step using remote DSN verification and rerun the RDF Views workflow.
• Audit metadata and backup RDF metadata before a major schema migration or Virtuoso upgrade.
• Tune SPARQL queries and Virtuoso configuration to improve response time for a public GraphQL endpoint.