TextQuery

TextQuery is a desktop application that allows users to import, query, modify, and visualize raw data using SQL, solving the problem of complex data analysis without requiring schema definitions or coding. It targets data analysts, developers, and other professionals in small to large organizations who need to work with local data files. The app is positioned as a privacy-focused, one-time purchase alternative to subscription-based analytics tools, offering a familiar SQL interface and local processing.

Key features

• Import data files without schema definition
• SQL editor with autocomplete
• Query history and favorites
• Query formatter
• Multiple selections
• Create line, bar, area, scatter, pie charts
• Customize chart title, description, colors
• Export charts to file or clipboard
• Inline editor for quick value edits
• Filters to narrow table rows
• Tabs for multiple queries and tables
• Export data in CSV, JSON, Excel, SQL
• Keyboard shortcuts for frequent functions
• Privacy: no usage recording or sending
• Perpetual license with free updates