query_raw
Execute raw VTQL queries on VTENext CRM for read-only data retrieval. Use this tool to directly query Potentials, Contacts, and other modules using VTQL syntax.
Instructions
Esegue una query VTQL grezza su VTENext (solo lettura)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | Query VTQL (es. SELECT * FROM Potentials LIMIT 5) |
Implementation Reference
- index.js:197-210 (handler)The 'query_raw' tool is registered and implemented in index.js, handling raw VTQL SELECT queries and executing them using the 'client.query' method.
server.tool( 'query_raw', 'Esegue una query VTQL grezza su VTENext (solo lettura)', { query: z.string().describe('Query VTQL (es. SELECT * FROM Potentials LIMIT 5)'), }, async ({ query }) => { if (!/^SELECT/i.test(query.trim())) { return { content: [{ type: 'text', text: 'Errore: solo query SELECT permesse.' }] }; } const results = await client.query(query); return { content: [{ type: 'text', text: JSON.stringify(results, null, 2) }], };