Gravatar Wrapper

Gravatar is Automattic's globally recognized avatar service. Users create a profile once and it follows them across any Gravatar-enabled site, providing a consistent identity including avatar images, display names, job titles, verified accounts, and more.

The Gravatar Wrapper lets you look up public Gravatar profile data directly from Postgres by email address. Query avatar URLs, display names, locations, verified accounts, and contact info with plain SQL and join them against your application data. All queries require an email = condition and return no results without one. It is read-only and works with Supabase Vault for secure API key management. This wrapper is contributed and maintained by Automattic.

Preparation

Before you get started, make sure the wrappers extension is installed on your database:

and then enable the Wasm foreign data wrapper:

Secure your credentials (optional)

By default, Postgres stores FDW credentials inside pg_catalog.pg_foreign_server in plain text. Anyone with access to this table will be able to view these credentials. Wrappers is designed to work with Vault, which provides an additional level of security for storing credentials. We recommend using Vault to store your credentials.

Connecting to Gravatar

We need to provide Postgres with the credentials to access Gravatar, and any additional options. We can do this using the create server command:

With Vault:

Without Vault:

Note: the fdw_package_* options are required and specify the Wasm package metadata. See the Available Versions table above for the full list.

Resources

• Official Gravatar wrapper documentation
• Enable in Supabase dashboard
• supabase/wrappers on GitHub
• Gravatar API documentation
• Gravatar product page