SQLite Expert is a database administration application for SQLite databases. Easy to use, with a clean gui and plenty of commonly used options when designing and optimizing an SQLite database.

Available in Personal and Professional Edition, where personal edition is completely free (no nag screens or expiration dates) and should be enough for most users. The professional version is not free, but offers visual query builder, visual table designer and other "professional" features.