Function extractMetadataInternal

pkg/mcp/tools.go:126–156

extractMetadataInternal parses a SQL string and extracts tables, columns, and functions.

(sql string)

// extractMetadataInternal parses a SQL string and extracts tables, columns, and functions.
func extractMetadataInternal(sql string) (map[string]any, error) {
	if sql == "" {
		return nil, fmt.Errorf("parameter 'sql' is required and must not be empty")
	}

	tree, err := gosqlx.Parse(sql)
	if err != nil {
		return nil, fmt.Errorf("parse failed: %w", err)
	}

	meta := gosqlx.ExtractMetadata(tree)

	tables := meta.Tables
	if tables == nil {
		tables = []string{}
	}
	columns := meta.Columns
	if columns == nil {
		columns = []string{}
	}
	functions := meta.Functions
	if functions == nil {
		functions = []string{}
	}

	return map[string]any{
		"tables":    tables,
		"columns":   columns,
		"functions": functions,
	}, nil
}

// securityScanInternal scans a SQL string for injection patterns and other threats.
func securityScanInternal(sql string) (map[string]any, error) {