georgysavva/scany

Health v2 · maintenance only

Adoption not part of the score

1522 stars · 75 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

scany is a Go library that scans rows from a database into Go structs, maps, and primitive types with a single function call, eliminating manual row iteration. It works with database/sql and pgx's native interface and is explicitly not an ORM, since it only maps query results into objects.

Use cases

• scan sql query results into go structs
• map database rows to structs without an orm
• use pgx with struct scanning
• avoid verbose rows.Next iteration code in go
• scan nested and embedded structs from database columns
• handle null columns when scanning into go types

When to choose

• you use database/sql or pgx directly and want to skip manual row scanning
• you want ORM-like convenience for reading data without query building or relation handling
• you need to scan into nested, embedded, or composite Go types

When to avoid

• you need a full ORM with query building and relation management
• you need write-side mapping of structs to SQL statements
• you don't use Go

Facets

library · maturity stable

database-driver orm serialization databases backend developer-tools go windows cross-platform go sql row-scanning pgx database-sql struct-mapping postgresql mysql linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="georgysavva/scany")