SQLite MCP Server

2025-03-07 11:22:25,758 - create_log_db - INFO - Creating log database: logs.db 2025-03-07 11:22:26,000 - create_log_db - INFO - Removed existing logs.db 2025-03-07 11:22:26,005 - create_log_db - INFO - Found 15 .gz files: server.2025-02-19.14.log.gz, server.2025-02-19.7.log.gz, server.2025-02-19.9.log.gz, server.2025-02-19.5.log.gz, server.2025-02-19.1.log.gz, server.2025-02-19.12.log.gz, server.2025-02-19.10.log.gz, server.2025-02-19.3.log.gz, server.2025-02-19.6.log.gz, server.2025-02-19.8.log.gz, server.2025-02-19.4.log.gz, server.2025-02-19.13.log.gz, server.2025-02-19.0.log.gz, server.2025-02-19.2.log.gz, server.2025-02-19.11.log.gz 2025-03-07 11:22:26,005 - create_log_db - INFO - Processing server.2025-02-19.14.log.gz... 2025-03-07 11:22:26,161 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:26,307 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:26,475 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:26,634 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:26,778 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:26,924 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:27,090 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:27,235 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:27,394 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:27,538 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:27,684 - create_log_db - INFO - Processed 1100000 lines... 2025-03-07 11:22:27,712 - create_log_db - INFO - Finished processing server.2025-02-19.14.log.gz: 13056 logs, 4650 stack traces, 0 errors 2025-03-07 11:22:27,712 - create_log_db - INFO - Processing server.2025-02-19.7.log.gz... 2025-03-07 11:22:27,862 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:28,005 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:28,153 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:28,324 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:28,486 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:28,636 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:28,791 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:28,936 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:29,094 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:29,248 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:29,369 - create_log_db - INFO - Finished processing server.2025-02-19.7.log.gz: 52432 logs, 5438 stack traces, 0 errors 2025-03-07 11:22:29,369 - create_log_db - INFO - Processing server.2025-02-19.9.log.gz... 2025-03-07 11:22:29,521 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:29,668 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:29,827 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:29,978 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:30,143 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:30,303 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:30,448 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:30,610 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:30,756 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:30,914 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:31,029 - create_log_db - INFO - Finished processing server.2025-02-19.9.log.gz: 43390 logs, 5387 stack traces, 0 errors 2025-03-07 11:22:31,029 - create_log_db - INFO - Processing server.2025-02-19.5.log.gz... 2025-03-07 11:22:31,181 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:31,334 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:31,490 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:31,637 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:31,986 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:32,147 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:32,298 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:32,457 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:32,607 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:32,769 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:32,893 - create_log_db - INFO - Finished processing server.2025-02-19.5.log.gz: 45088 logs, 6025 stack traces, 0 errors 2025-03-07 11:22:32,893 - create_log_db - INFO - Processing server.2025-02-19.1.log.gz... 2025-03-07 11:22:33,046 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:33,194 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:33,352 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:33,496 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:33,658 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:33,801 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:33,956 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:34,124 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:34,269 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:34,427 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:34,580 - create_log_db - INFO - Finished processing server.2025-02-19.1.log.gz: 33527 logs, 4534 stack traces, 0 errors 2025-03-07 11:22:34,581 - create_log_db - INFO - Processing server.2025-02-19.12.log.gz... 2025-03-07 11:22:34,732 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:34,875 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:35,034 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:35,180 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:35,327 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:35,489 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:35,643 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:35,806 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:35,954 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:36,119 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:36,268 - create_log_db - INFO - Processed 1100000 lines... 2025-03-07 11:22:36,328 - create_log_db - INFO - Finished processing server.2025-02-19.12.log.gz: 17344 logs, 4862 stack traces, 0 errors 2025-03-07 11:22:36,328 - create_log_db - INFO - Processing server.2025-02-19.10.log.gz... 2025-03-07 11:22:36,473 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:36,622 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:36,768 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:36,916 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:37,088 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:37,253 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:37,406 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:37,554 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:37,727 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:37,873 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:38,040 - create_log_db - INFO - Processed 1100000 lines... 2025-03-07 11:22:38,046 - create_log_db - INFO - Finished processing server.2025-02-19.10.log.gz: 12081 logs, 4108 stack traces, 0 errors 2025-03-07 11:22:38,047 - create_log_db - INFO - Processing server.2025-02-19.3.log.gz... 2025-03-07 11:22:38,198 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:38,362 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:38,510 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:38,700 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:38,863 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:39,011 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:39,173 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:39,322 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:39,495 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:39,647 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:39,744 - create_log_db - INFO - Finished processing server.2025-02-19.3.log.gz: 67440 logs, 5971 stack traces, 0 errors 2025-03-07 11:22:39,744 - create_log_db - INFO - Processing server.2025-02-19.6.log.gz... 2025-03-07 11:22:39,897 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:40,047 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:40,222 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:40,373 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:40,540 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:40,686 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:40,831 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:41,007 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:41,157 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:41,311 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:41,508 - create_log_db - INFO - Processed 1100000 lines... 2025-03-07 11:22:41,522 - create_log_db - INFO - Finished processing server.2025-02-19.6.log.gz: 18784 logs, 4211 stack traces, 0 errors 2025-03-07 11:22:41,522 - create_log_db - INFO - Processing server.2025-02-19.8.log.gz... 2025-03-07 11:22:41,674 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:41,847 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:41,999 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:42,186 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:42,339 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:42,499 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:42,667 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:42,819 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:42,995 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:43,150 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:43,282 - create_log_db - INFO - Finished processing server.2025-02-19.8.log.gz: 46778 logs, 5948 stack traces, 0 errors 2025-03-07 11:22:43,282 - create_log_db - INFO - Processing server.2025-02-19.4.log.gz... 2025-03-07 11:22:43,438 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:43,606 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:43,760 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:43,953 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:44,125 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:44,298 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:44,479 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:44,655 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:44,820 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:44,993 - create_log_db - INFO - Finished processing server.2025-02-19.4.log.gz: 143681 logs, 7323 stack traces, 0 errors 2025-03-07 11:22:44,993 - create_log_db - INFO - Processing server.2025-02-19.13.log.gz... 2025-03-07 11:22:45,143 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:45,290 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:45,456 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:45,609 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:45,775 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:45,926 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:46,094 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:46,245 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:46,395 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:46,565 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:46,723 - create_log_db - INFO - Finished processing server.2025-02-19.13.log.gz: 19648 logs, 4976 stack traces, 0 errors 2025-03-07 11:22:46,723 - create_log_db - INFO - Processing server.2025-02-19.0.log.gz... 2025-03-07 11:22:46,876 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:47,033 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:47,210 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:47,360 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:47,528 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:47,692 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:47,841 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:47,989 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:48,151 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:48,304 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:48,445 - create_log_db - INFO - Finished processing server.2025-02-19.0.log.gz: 50846 logs, 4880 stack traces, 0 errors 2025-03-07 11:22:48,445 - create_log_db - INFO - Processing server.2025-02-19.2.log.gz... 2025-03-07 11:22:48,594 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:48,747 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:48,900 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:49,069 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:49,215 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:49,361 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:49,527 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:49,674 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:49,821 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:49,981 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:50,142 - create_log_db - INFO - Finished processing server.2025-02-19.2.log.gz: 18480 logs, 3778 stack traces, 0 errors 2025-03-07 11:22:50,142 - create_log_db - INFO - Processing server.2025-02-19.11.log.gz... 2025-03-07 11:22:50,292 - create_log_db - INFO - Processed 100000 lines... 2025-03-07 11:22:50,441 - create_log_db - INFO - Processed 200000 lines... 2025-03-07 11:22:50,587 - create_log_db - INFO - Processed 300000 lines... 2025-03-07 11:22:50,760 - create_log_db - INFO - Processed 400000 lines... 2025-03-07 11:22:50,905 - create_log_db - INFO - Processed 500000 lines... 2025-03-07 11:22:51,054 - create_log_db - INFO - Processed 600000 lines... 2025-03-07 11:22:51,231 - create_log_db - INFO - Processed 700000 lines... 2025-03-07 11:22:51,378 - create_log_db - INFO - Processed 800000 lines... 2025-03-07 11:22:51,539 - create_log_db - INFO - Processed 900000 lines... 2025-03-07 11:22:51,684 - create_log_db - INFO - Processed 1000000 lines... 2025-03-07 11:22:51,831 - create_log_db - INFO - Processed 1100000 lines... 2025-03-07 11:22:51,897 - create_log_db - INFO - Finished processing server.2025-02-19.11.log.gz: 10215 logs, 4141 stack traces, 0 errors 2025-03-07 11:22:51,897 - create_log_db - INFO - Creating indexes... 2025-03-07 11:22:54,458 - create_log_db - INFO - Database created successfully! 2025-03-07 11:22:54,458 - create_log_db - INFO - Total regular logs: 592790 2025-03-07 11:22:54,458 - create_log_db - INFO - Total stack traces: 76232 2025-03-07 11:22:54,458 - create_log_db - INFO - Total parsing errors: 0 2025-03-07 11:22:54,458 - create_log_db - INFO - Log level distribution: INFO: 376136 WARN: 206365 ERROR: 10289 2025-03-07 11:22:54,458 - create_log_db - INFO - Database file: /Users/colin/mcp-test/logs.db