{"id":54671,"library":"groovy-sql","title":"Groovy SQL","description":"Groovy SQL provides a simpler and more Groovy-like API for working with JDBC, making database operations more concise and expressive.","status":"active","version":"3.0.25","language":"java","source_language":null,"source_url":"https://github.com/apache/groovy","tags":["groovy","sql","database","jdbc"],"install":[{"cmd":"<dependency>\n  <groupId>org.codehaus.groovy</groupId>\n  <artifactId>groovy-sql</artifactId>\n  <version>3.0.25</version>\n</dependency>","lang":"xml","label":"Maven"},{"cmd":"implementation 'org.codehaus.groovy:groovy-sql:3.0.25'","lang":"groovy","label":"Gradle"}],"dependencies":[],"imports":[{"symbol":"Sql","correct":"groovy.sql.Sql"}],"quickstart":{"code":"import groovy.sql.Sql\n\ndef sql = Sql.newInstance('jdbc:h2:mem:test', 'sa', '', 'org.h2.Driver')\nsql.execute('CREATE TABLE users (id INT, name VARCHAR(255))')\nsql.execute(\"INSERT INTO users VALUES (1, 'Alice')\")\nsql.eachRow('SELECT * FROM users') { row -> println \"${row.id}: ${row.name}\" }","lang":"java","description":"Minimal Groovy SQL usage to connect to an H2 in-memory database, create a table, insert a row, and query it."},"warnings":[],"env_vars":null,"search_vec":"'api':13 'concis':22 'databas':19,27 'express':24 'groovi':1,3,11,25 'groovy-lik':10 'jdbc':17,28 'like':12 'make':18 'oper':20 'provid':5 'simpler':7 'sql':2,4,26 'work':15","created_at":"2026-06-15T09:18:41.409111+00:00","updated_at":"2026-06-15T09:18:41.409111+00:00","problems":[],"ecosystem":"maven","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://groovy-lang.org","github":"https://github.com/apache/groovy","docs":"https://appdoc.app/artifact/org.codehaus.groovy/groovy-sql/","changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-15","next_check":"2026-12-12","install_tag":null}}