JimSql = Jim Isn't MySQL. Jim is a filesystem database system implemention use Java.

• JDK 21+ (set JAVA_HOME to a JDK 21 installation)
• Maven 3.9+

• SELECT explicit projection honored; right-side columns labeled as alias.col
• JOIN execution fixes; WHERE extended (AND/OR/NOT, IN/NOT IN, LIKE/NOT LIKE, IS [NOT] NULL; case-insensitive columns; numeric-aware compare)
• Built-in function ask_llm(prompt[, named overrides]) backed by llm.csv; providers: openai/openai_compatible/openai_response/ollama; DRYRUN via env JIMSQL_LLM_DRYRUN=true; logs mask api_key
• Logging: logback-based; INFO prints SQL; DEBUG prints plan/join/where/llm
• JDBC PreparedStatement: minimal executeQuery/executeUpdate/execute with client-side parameter binding# Useage

use docker-compose to start a server

version: '3'services: jimsql: privileged: trueimage: dafei1288/jimsql_server:1.0.0ports: - "8821:8821" - "8825:8825"# volumes:# - "./data:/jimsql/data"environment: # JAVA_OPTS: -agentlib:jdwp=transport=dt_socket,address=*:8825,server=y,suspend=nJAVA_ARGS: 8821 0.0.0.0 /jimsql/data

Use snapshot repository

 <repositories> <repository> <id>jim</id> <url>https://oss.sonatype.org/content/repositories/snapshots</url> </repository> </repositories>

Then use jdbc to connect

<dependency> <groupId>com.dafei1288</groupId> <artifactId>jdbc</artifactId> <version>1.0.0-SNAPSHOT</version> </dependency>

importjava.sql.*; publicclassTestServer{publicstaticvoidmain(String[] args) throwsException{Class.forName("com.dafei1288.jimsql.jdbc.JqDriver"); // legacy: OK only for DML; jspv1: returns UPDATE_COUNTConnectionconn = DriverManager.getConnection("jdbc:jimsql://localhost:8821/test?protocol=jspv1"); Statementstmt = conn.createStatement(); // SELECTtry (ResultSetrs = stmt.executeQuery("select id,name,age from user where age >= 3 order by id desc")){while (rs.next()){System.out.printf("id=%s name=%s age=%s%n", rs.getString("id"), rs.getString("name"), rs.getString("age"))} } // UPDATE (jspv1 only returns affected rows)intn1 = stmt.executeUpdate("UPDATE test.user SET age = 23 WHERE id = 1"); // DELETEintn2 = stmt.executeUpdate("DELETE FROM test.user WHERE id = 3"); System.out.printf("updated=%d deleted=%d%n", n1, n2)} }

See more examples in docs/dml-examples.md.

• AND/OR/NOT with parentheses; comparisons = != > >= < <=; IS NULL/IS NOT NULL; LIKE/NOT LIKE; IN/NOT IN.
• Case-insensitive column names; numeric vs string comparison based on table metadata.
• CSV NULL semantics: empty string is treated as NULL for IS NULL checks.

Examples:

SELECT id,name,age FROM user WHERE age =3OR (age =22AND name LIKE'ja%') ORDER BY id DESC; SELECT id,name FROM user WHERE name IN ('jacky','doudou') AND age IS NOT NULL;

• Functions: COUNT(*|col), SUM(col), AVG(col), MIN(col), MAX(col)
• GROUP BY/HAVING supported; aggregate labels: count/sum_<col>/avg_<col>/min_<col>/max_<col>
• Types: COUNT -> BIGINT; SUM/AVG -> DECIMAL; MIN/MAX -> source column type
• CSV NULL semantics: empty string treated as NULL; COUNT(col) skips empties; SUM/AVG skip empties; MIN/MAX ignore empties

Examples:

SELECTSUM(age), AVG(age), MIN(age), MAX(age) FROM user; SELECT age, COUNT(*) FROM user GROUP BY age HAVING count >0; SELECT age, SUM(age), AVG(age), MIN(age), MAX(age) FROM user GROUP BY age;

• Filesystem-backed CSV database; simple, visible, easy to integrate
• Lightweight Netty server; fast startup; low footprint
• JDBC driver with PreparedStatement; protocols: legacy/jspv1 (DML update count semantics)
• SQL engine: SELECT projection; WHERE (AND/OR/NOT, (), comparisons, LIKE, IN, IS [NOT] NULL); JOIN (INNER/LEFT/CROSS); GROUP BY/HAVING + aggregates; ORDER BY/LIMIT
• DML: INSERT/UPDATE/DELETE (CSV backend)
• SHOW/DESC/EXPLAIN: SHOW DATABASES/TABLES/DESCRIBE/SHOW CREATE TABLE/EXPLAIN
• Built-in ask_llm: providers openai/openai_compatible/openai_response/ollama; DRYRUN via JIMSQL_LLM_DRYRUN
• MCP integration: stdio; env-based connection (JIMSQL_URL or host/port/db/user/password)
• Logging: logback; INFO SQL; DEBUG plan/join/where/llm; secrets masked
• Docker: official image + compose example