Lens Protocol BigQuery Schemas

Tables Schema of Lens Chain BigQuery.

Account Schema

The Account Schema manages user account information and relationships. It tracks user profiles, followers, actions, metadata, and interactions between users. This schema is central to user identity and social connections in the platform.

Hex Adresss, i.e. account, post, in the dataset is stored in its raw binary format (bytea). Lens provide a public function called FORMAT_HEX that converts BigQuery's \x format to the standard Web3 0x format.

SELECT  account as original_account_address,  `lens-protocol-mainnet.account.FORMAT_HEX`(account) as web3_formatted_account_addressFROM `lens-protocol-mainnet.account.post_summary`LIMIT 5;

Account Schema Tables

account.acted - Records actions performed by accounts on posts
account.action_config - Stores action configurations for accounts
account.action_executed - Logs executed actions by accounts
account.action_executed_by_account_count - Counts actions executed by specific accounts
account.action_executed_count - Counts actions executed on specific accounts
account.action_metadata - Stores metadata for account actions
account.blocked - Records blocked accounts
account.bookmarked_post - Stores posts bookmarked by accounts
account.follow_rule_config - Configurations for follow rules
account.follow_rule_selector - Selectors for follow rules
account.follower - Records follower relationships
account.follower_summary - Summarizes follower statistics
account.known_smart_wallet - Records known smart wallets
account.manager - Records account managers
account.metadata - Stores account metadata
account.notification - Stores account notifications
account.peer_to_peer_recommendation - Records peer-to-peer account recommendations
account.post_summary - Summarizes post statistics for accounts
account.reacted_summary - Summarizes reactions by account
account.reaction_summary - Summarizes reactions on account content
account.universal_action_config - Stores universal action configurations
account.username_assigned - Records username assignments

account.acted

Records actions performed by accounts on posts.

Previous was publication.open_action_module_acted_record in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.acted` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
account	bytea	Account address that performed the action
post	bytea	Post identifier
action_id	integer	Action identifier
implementation	bytea	Implementation address
action_data	text	Action data
is_collect	boolean	Whether action is a collect
tx_hash	bytea	Transaction hash
block_hash	bytea	Hash of the block containing this record
timestamp	timestamp with time zone	Action time
sequence_id	numeric	Sequence identifier

Back to Account Schema

account.action_config

Stores action configurations for accounts.

SELECT * FROM `lens-protocol-mainnet.account.action_config` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
action_address	bytea	Action address
type	USER-DEFINED	Action type
account	bytea	Account address
raw_config_params	jsonb	Raw configuration parameters
decoded_config_params	jsonb	Decoded configuration parameters
disabled	boolean	Whether action is disabled
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
disable_extra_data	bytea	Disable extra data
enable_extra_data	bytea	Enable extra data
last_updated_sequence_id	numeric	Last update sequence ID
return_data	bytea	Return data
app	bytea	App identifier

Back to Account Schema

account.action_executed

Logs executed actions by accounts.

SELECT * FROM `lens-protocol-mainnet.account.action_executed` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
action_address	bytea	Action address
type	USER-DEFINED	Action type
on_account	bytea	Account the action was performed on
raw_params	jsonb	Raw parameters
decoded_params	jsonb	Decoded parameters
timestamp	timestamp with time zone	Execution time
sequence_id	numeric	Sequence identifier
app	bytea	App identifier
by_account	bytea	Account that executed the action

Back to Account Schema

account.action_executed_by_account_count

Counts actions executed by specific accounts.

SELECT * FROM `lens-protocol-mainnet.account.action_executed_by_account_count` LIMIT 1;

Column	Type	Description
action_address	bytea	Action address
by_account	bytea	Account that executed the action
total	integer	Total count of executions

Back to Account Schema

account.action_executed_count

Counts actions executed on specific accounts.

SELECT * FROM `lens-protocol-mainnet.account.action_executed_count` LIMIT 1;

Column	Type	Description
action_address	bytea	Action address
account	bytea	Account address
total	integer	Total count of executions

Back to Account Schema

account.action_metadata

Stores metadata for account actions.

SELECT * FROM `lens-protocol-mainnet.account.action_metadata` LIMIT 1;

Column	Type	Description
action	bytea	Action address
metadata_uri	character varying	URI for the metadata
metadata_snapshot_location_url	character varying	URL for metadata snapshot
metadata	jsonb	Stored metadata
name	character varying	Action name
description	character varying	Action description
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to Account Schema

account.blocked

Records blocked accounts.

Previous was profile.blocked in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.blocked` LIMIT 1;

Column	Type	Description
account	bytea	Blocked account address
blocking_account	bytea	Account doing the blocking
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Block time
sequence_id	numeric	Sequence identifier

Back to Account Schema

account.bookmarked_post

Stores posts bookmarked by accounts.

Previous was personalisation.bookmarked_publication in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.bookmarked_post` LIMIT 1;

Column	Type	Description
account	bytea	Account address
post	bytea	Bookmarked post identifier
created_at	timestamp with time zone	Bookmark time

Back to Account Schema

account.follow_rule_config

Configurations for follow rules.

SELECT * FROM `lens-protocol-mainnet.account.follow_rule_config` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
rule_address	bytea	Rule address
config_salt	bytea	Configuration salt
type	USER-DEFINED	Rule type
graph	bytea	Graph identifier
account	bytea	Account address
raw_config_params	jsonb	Raw configuration parameters
decoded_config_params	jsonb	Decoded configuration parameters
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
last_updated_sequence_id	numeric	Last update sequence ID

Back to Account Schema

account.follow_rule_selector

Selectors for follow rules.

SELECT * FROM `lens-protocol-mainnet.account.follow_rule_selector` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
config_salt	bytea	Configuration salt
selector	USER-DEFINED	Rule selector
is_required	boolean	Whether the rule is required
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
graph	bytea	Graph identifier
account	bytea	Account address
rule_address	bytea	Rule address

Back to Account Schema

account.follower

Records follower relationships.

Previous was profile.follower in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.follower` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
account_following	bytea	Account being followed
account_follower	bytea	Account doing the following
graph	bytea	Graph identifier
follow_id	character varying	Follow identifier
tx_hash	bytea	Transaction hash
block_hash	bytea	Hash of the block containing this record
timestamp	timestamp with time zone	Follow time
sequence_id	numeric	Sequence identifier

Back to Account Schema

account.follower_summary

Summarizes follower statistics.

Previous was global_stats.profile_follower in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.follower_summary` LIMIT 1;

Column	Type	Description
account	bytea	Account address
total_followers	integer	Total number of followers
total_following	integer	Total number of accounts followed
graph	bytea	Graph identifier
updated_at	timestamp with time zone	Last update time

Back to Account Schema

account.known_smart_wallet

Records known smart wallets.

SELECT * FROM `lens-protocol-mainnet.account.known_smart_wallet` LIMIT 1;

Column	Type	Description
address	bytea	Wallet address
owned_by	bytea	Owner address
legacy_profile_id	character varying	Legacy profile ID
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier
last_updated_sequence_id	numeric	Last update sequence ID

Back to Account Schema

account.manager

Records account managers.

Previous was profile.manager in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.manager` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
account	bytea	Account address
manager	bytea	Manager address
is_hidden	boolean	Whether manager is hidden
can_execute_transactions	boolean	Transaction execution permission
can_transfer_tokens	boolean	Token transfer permission
can_transfer_native	boolean	Native transfer permission
can_set_metadata_uri	boolean	Metadata URI setting permission
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier
last_updated_sequence_id	numeric	Last update sequence ID

Back to Account Schema

account.metadata

Stores account metadata.

Previous was profile.metadata in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.metadata` LIMIT 1;

Column	Type	Description
account	bytea	Account address
metadata_uri	character varying	URI for the metadata
metadata_snapshot_location_url	character varying	URL for metadata snapshot
metadata	jsonb	Stored metadata
name	character varying	Account name
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time
app	bytea	App identifier

Back to Account Schema

account.notification

Stores account notifications.

Previous was notification.record in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.notification` LIMIT 1;

Column	Type	Description
notification_id	integer	Unique identifier
generated_notification_id	character varying	Generated notification ID
type	character varying	Notification type
post	bytea	Post identifier
post_pointer	bytea	Post pointer
receiving_account	bytea	Account receiving the notification
sender_account	bytea	Account sending the notification
action_date	timestamp with time zone	Action date
reaction	USER-DEFINED	Reaction type
open_action_acted	bytea	Open action identifier
is_collect	boolean	Whether action is a collect
app	bytea	App identifier
graph	bytea	Graph identifier
feed	bytea	Feed identifier

Back to Account Schema

account.peer_to_peer_recommendation

Records peer-to-peer account recommendations.

Previous was profile.peer_to_peer_recommendation in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.peer_to_peer_recommendation` LIMIT 1;

Column	Type	Description
account	bytea	Account address
account_recommendation	bytea	Recommended account address
created_at	timestamp with time zone	Recommendation time

Back to Account Schema

account.post_summary

Summarizes post statistics for accounts.

Previous was global_stats.profile in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.post_summary` LIMIT 1;

Column	Type	Description
account	bytea	Account address
feed	bytea	Feed identifier
total_posts	integer	Total number of posts
total_comments	integer	Total number of comments
total_reposts	integer	Total number of reposts
total_quotes	integer	Total number of quotes
total_reacted	integer	Total times account reacted
total_reactions	integer	Total reactions received
total_collects	integer	Total collects
updated_at	timestamp with time zone	Last update time
total_main	integer	Total main posts
total_tips	integer	Total tips

Repost/Mirros are not migrated from Lens V2. Total_reposts may not represent the actual numbers from Lens V2

Back to Account Schema

account.reacted_summary

Summarizes reactions by account.

Previous was global_stats.profile_reacted in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.reacted_summary` LIMIT 1;

Column	Type	Description
account	bytea	Account address
reaction_type	USER-DEFINED	Type of reaction
total	integer	Total count

Back to Account Schema

account.reaction_summary

Summarizes reactions on account content.

Previous was global_stats.profile_reaction in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.reaction_summary` LIMIT 1;

Column	Type	Description
account	bytea	Account address
reaction_type	USER-DEFINED	Type of reaction
total	integer	Total count

Back to Account Schema

account.universal_action_config

Stores universal action configurations.

SELECT * FROM `lens-protocol-mainnet.account.universal_action_config` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
action_address	bytea	Action address
type	USER-DEFINED	Action type
raw_config_params	jsonb	Raw configuration parameters
decoded_config_params	jsonb	Decoded configuration parameters
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier

Back to Account Schema

account.username_assigned

Records username assignments.

Previous was namespace.handle_link in Lens V2

SELECT * FROM `lens-protocol-mainnet.account.username_assigned` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
account	bytea	Account address
namespace	bytea	Namespace identifier
local_name	character varying	Local username
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Assignment time
sequence_id	numeric	Sequence identifier

Back to Account Schema

App Schema

The App Schema manages application-related data, including app records, feeds, groups, and metadata. It tracks app-specific statistics, signers, users, and their interactions with the platform. This schema enables apps to maintain their own configurations and track usage metrics.

App Schema Tables

app.account_post_summary - Summarizes post statistics for accounts by app
app.account_reacted_summary - Summarizes reactions by account per app
app.account_reaction_summary - Summarizes reactions on account content per app
app.feed - Records app feeds
app.group - Records app groups
app.metadata - Stores app metadata
app.post_feed_tag_summary - Summarizes post tags by feed and app
app.post_reaction_summary - Summarizes post reactions by app
app.post_summary - Summarizes post statistics by app
app.post_tag_summary - Summarizes post tags by app
app.record - Stores app records
app.signer - Records app signers
app.user - Records app users

app.account_post_summary

Summarizes post statistics for accounts by app.

Previous was app_stats.profile in Lens V2

SELECT * FROM `lens-protocol-mainnet.app.account_post_summary` LIMIT 1;

Column	Type	Description
account	bytea	Account address
feed	bytea	Feed identifier
app	bytea	App identifier
total_main	integer	Total main posts
total_comments	integer	Total comments
total_reposts	integer	Total reposts
total_quotes	integer	Total quotes
total_posts	integer	Total posts
total_reacted	integer	Total times account reacted
total_reactions	integer	Total reactions received
total_collects	integer	Total collects
updated_at	timestamp with time zone	Last update time
total_tips	integer	Total tips

Repost/Mirros are not migrated from Lens V2. Total_reposts may not represent the actual numbers from Lens V2

Back to App Schema

app.account_reacted_summary

Summarizes reactions by account per app.

Previous was app_stats.profile_reacted in Lens V2

SELECT * FROM `lens-protocol-mainnet.app.account_reacted_summary` LIMIT 1;

Column	Type	Description
account	bytea	Account address
app	bytea	App identifier
reaction_type	USER-DEFINED	Type of reaction
total	integer	Total count

Back to App Schema

Column	Type	Description
account	bytea	Account address
app	bytea	App identifier
reaction_type	USER-DEFINED	Type of reaction
total	integer	Total count

Back to App Schema

app.feed

Records app feeds.

SELECT * FROM `lens-protocol-mainnet.app.feed` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
app	bytea	App identifier
feed	bytea	Feed identifier
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to App Schema

app.group

Records app groups.

SELECT * FROM `lens-protocol-mainnet.app.group` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
app	bytea	App identifier
group	bytea	Group identifier
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to App Schema

app.metadata

Stores app metadata.

SELECT * FROM `lens-protocol-mainnet.app.metadata` LIMIT 1;

Column	Type	Description
app	bytea	App identifier
metadata_uri	character varying	URI for the metadata
metadata_snapshot_location_url	character varying	URL for metadata snapshot
metadata	jsonb	Stored metadata
name	character varying	App name
icon	character varying	App icon URL
tagline	character varying	App tagline
description	character varying	App description
website	character varying	App website
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to App Schema

app.post_feed_tag_summary

Summarizes post tags by feed and app.

SELECT * FROM `lens-protocol-mainnet.app.post_feed_tag_summary` LIMIT 1;

Column	Type	Description
tag	character varying	Tag name
app	bytea	App identifier
feed	bytea	Feed identifier
total	integer	Total count

Back to App Schema

Summarizes post reactions by app.

Previous was app_stats.publication_reaction in Lens V2

SELECT * FROM `lens-protocol-mainnet.app.post_reaction_summary` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
app	bytea	App identifier
reaction_type	USER-DEFINED	Type of reaction
total	integer	Total count

Back to App Schema

app.post_summary

Summarizes post statistics by app.

Previous was app_stats.publication in Lens V2

SELECT * FROM `lens-protocol-mainnet.app.post_summary` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
app	bytea	App identifier
total_amount_of_collects	integer	Total collects
total_amount_of_collects_by_flagged_accounts	integer	Collects by flagged accounts
total_amount_of_acted	integer	Total actions
total_amount_of_acted_by_flagged_accounts	integer	Actions by flagged accounts
total_amount_of_reposts	integer	Total reposts
total_amount_of_reposts_by_flagged_accounts	integer	Reposts by flagged accounts
total_amount_of_comments	integer	Total comments
total_amount_of_comments_by_flagged_accounts	integer	Comments by flagged accounts
total_amount_of_comments_hidden_by_author	integer	Comments hidden by author
total_amount_of_quotes	integer	Total quotes
total_amount_of_quotes_by_flagged_accounts	integer	Quotes by flagged accounts
total_reactions	integer	Total reactions
total_reactions_by_flagged_accounts	integer	Reactions by flagged accounts
total_bookmarks	integer	Total bookmarks
total_bookmarks_by_flagged_accounts	integer	Bookmarks by flagged accounts
total_amount_of_tips	integer	Total tips
total_amount_of_tips_by_flagged_accounts	integer	Tips by flagged accounts

Repost/Mirros are not migrated from Lens V2. Total_reposts may not represent the actual numbers from Lens V2

Back to App Schema

app.post_tag_summary

Summarizes post tags by app.

Previous was app_stats.publication_tag in Lens V2

SELECT * FROM `lens-protocol-mainnet.app.post_tag_summary` LIMIT 1;

Column	Type	Description
tag	character varying	Tag name
app	bytea	App identifier
total	integer	Total count

Back to App Schema

app.record

Stores app records.

SELECT * FROM `lens-protocol-mainnet.app.record` LIMIT 1;

Column	Type	Description
app	bytea	App identifier
graph	bytea	Graph identifier
graph_last_updated_sequence_id	numeric	Graph update sequence ID
sponsorship	bytea	Sponsorship identifier
sponsorship_last_updated_sequence_id	numeric	Sponsorship update sequence ID
namespace	bytea	Namespace identifier
namespace_last_updated_sequence_id	numeric	Namespace update sequence ID
default_feed	bytea	Default feed identifier
default_feed_last_updated_sequence_id	numeric	Default feed update sequence ID
treasury	bytea	Treasury address
treasury_last_updated_sequence_id	numeric	Treasury update sequence ID
source_stamp_verification_set	boolean	Source stamp verification status
source_stamp_verification_set_last_updated_sequence_id	numeric	Source stamp verification update sequence ID
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to App Schema

app.signer

Records app signers.

SELECT * FROM `lens-protocol-mainnet.app.signer` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
app	bytea	App identifier
signer	bytea	Signer address
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to App Schema

app.user

Records app users.

SELECT * FROM `lens-protocol-mainnet.app.user` LIMIT 1;

Column	Type	Description
app	bytea	App identifier
account	bytea	User account address
first_action_on	timestamp with time zone	First action time
last_action_on	timestamp with time zone	Last action time

Back to App Schema

Feed Schema

The Feed Schema manages content feeds in the platform. It stores feed metadata, records, and usage statistics. Feeds are used to organize and display content in different ways across the platform, allowing for custom content streams.

Feed Schema Tables

feed.metadata - Stores feed metadata
feed.record - Stores feed records
feed.record_stats - Records feed usage statistics

feed.metadata

Stores feed metadata.

SELECT * FROM `lens-protocol-mainnet.feed.metadata` LIMIT 1;

Column	Type	Description
feed	bytea	Feed identifier
metadata_uri	character varying	URI for the metadata
metadata_snapshot_location_url	character varying	URL for metadata snapshot
metadata	jsonb	Stored metadata
name	character varying	Feed name
description	character varying	Feed description
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to Feed Schema

feed.record

Stores feed records.

SELECT * FROM `lens-protocol-mainnet.feed.record` LIMIT 1;

Column	Type	Description
feed	bytea	Feed identifier
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to Feed Schema

feed.record_stats

Records feed usage statistics.

SELECT * FROM `lens-protocol-mainnet.feed.record_stats` LIMIT 1;

Column	Type	Description
feed	bytea	Feed identifier
used_by_apps_total	integer	Total app usage count

Back to Feed Schema

Graph Schema

The Graph Schema manages social graph data in the platform. It tracks relationships between users, stores graph metadata, and records usage statistics. This schema provides the foundation for social connections and interactions.

Graph Schema Tables

graph.metadata - Stores graph metadata
graph.record - Stores graph records
graph.record_stats - Records graph usage statistics

graph.metadata

Stores graph metadata.

SELECT * FROM `lens-protocol-mainnet.graph.metadata` LIMIT 1;

Column	Type	Description
graph	bytea	Graph identifier
metadata_uri	character varying	URI for the metadata
metadata_snapshot_location_url	character varying	URL for metadata snapshot
metadata	jsonb	Stored metadata
name	character varying	Graph name
description	character varying	Graph description
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to Graph Schema

graph.record

Stores graph records.

SELECT * FROM `lens-protocol-mainnet.graph.record` LIMIT 1;

Column	Type	Description
graph	bytea	Graph identifier
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to Graph Schema

graph.record_stats

Records graph usage statistics.

SELECT * FROM `lens-protocol-mainnet.graph.record_stats` LIMIT 1;

Column	Type	Description
graph	bytea	Graph identifier
used_by_apps_total	integer	Total app usage count

Back to Graph Schema

Group Schema

The Group Schema manages community groups in the platform. It tracks group members, banned users, membership requests, and group metadata. Groups provide a way for users to organize around common interests or purposes.

Group Schema Tables

group.banned - Records banned group members
group.member - Records group members
group.membership_approval_requests - Records membership approval requests
group.metadata - Stores group metadata
group.record - Stores group records
group.record_stats - Stores group statistics

group.banned

Records banned group members.

SELECT * FROM `lens-protocol-mainnet.group.banned` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
group	bytea	Group identifier
config_salt	bytea	Configuration salt
account	bytea	Banned account address
banned_by_account	bytea	Account that performed the ban
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Ban time
sequence_id	numeric	Sequence identifier

Back to Group Schema

group.member

Records group members.

SELECT * FROM `lens-protocol-mainnet.group.member` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
group	bytea	Group identifier
account	bytea	Member account address
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Membership time
sequence_id	numeric	Sequence identifier

Back to Group Schema

group.membership_approval_requests

Records membership approval requests.

SELECT * FROM `lens-protocol-mainnet.group.membership_approval_requests` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
group	bytea	Group identifier
config_salt	bytea	Configuration salt
account	bytea	Requesting account address
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Request time
sequence_id	numeric	Sequence identifier

Back to Group Schema

group.metadata

Stores group metadata.

SELECT * FROM `lens-protocol-mainnet.group.metadata` LIMIT 1;

Column	Type	Description
group	bytea	Group identifier
metadata_uri	character varying	URI for the metadata
metadata_snapshot_location_url	character varying	URL for metadata snapshot
metadata	jsonb	Stored metadata
name	character varying	Group name
icon	character varying	Group icon URL
description	character varying	Group description
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to Group Schema

group.record

Stores group records.

SELECT * FROM `lens-protocol-mainnet.group.record` LIMIT 1;

Column	Type	Description
group	bytea	Group identifier
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to Group Schema

group.record_stats

Stores group statistics.

SELECT * FROM `lens-protocol-mainnet.group.record_stats` LIMIT 1;

Column	Type	Description
group	bytea	Group identifier
members_total	integer	Total number of members

Back to Group Schema

Metadata Schema

The Metadata Schema manages metadata processing and refresh operations across the platform. It tracks pending and failed metadata processing tasks and handles refresh requests for various entities in the system. This schema ensures metadata consistency and availability.

Metadata Schema Tables

metadata.failed - Records failed metadata processing
metadata.pending - Records pending metadata processing
metadata.refresh - Tracks metadata refresh requests

metadata.failed

Records failed metadata processing.

Previous was publication.failed in Lens V2

SELECT * FROM `lens-protocol-mainnet.metadata.failed` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
source	character varying	Source name
account	bytea	Related account identifier
graph	bytea	Related graph identifier
post	bytea	Related post identifier
feed	bytea	Related feed identifier
group	bytea	Related group identifier
sponsorship	bytea	Related sponsorship identifier
app	bytea	Related app identifier
namespace	bytea	Related namespace identifier
metadata_uri	character varying	Metadata URI
reason	character varying	Failure reason
created_on	timestamp with time zone	Failure time
action	bytea	Related action identifier

Back to Metadata Schema

metadata.pending

Records pending metadata processing.

Previous was publication.pending in Lens V2

SELECT * FROM `lens-protocol-mainnet.metadata.pending` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
source	character varying	Source name
account	bytea	Related account identifier
graph	bytea	Related graph identifier
post	bytea	Related post identifier
feed	bytea	Related feed identifier
group	bytea	Related group identifier
sponsorship	bytea	Related sponsorship identifier
app	bytea	Related app identifier
namespace	bytea	Related namespace identifier
metadata_uri	character varying	Metadata URI
sequence_id	numeric	Sequence identifier
created_on	timestamp with time zone	Creation time
action	bytea	Related action identifier

Back to Metadata Schema

metadata.refresh

Tracks metadata refresh requests.

SELECT * FROM `lens-protocol-mainnet.metadata.refresh` LIMIT 1;

Column	Type	Description
id	uuid	Unique identifier
entity	text	Entity being refreshed
status	USER-DEFINED	Refresh status
reason	text	Refresh reason
updated_at	timestamp with time zone	Last update time
created_at	timestamp with time zone	Creation time

Back to Metadata Schema

ML Schema

The ML Schema (Machine Learning Schema) manages AI-powered features in the platform. It stores data related to account quality scores, personalized feeds, trending content, and reply rankings. This schema enables intelligent content discovery and moderation.

ML Schema Tables

ml.account_score - Records quality scores for accounts
ml.for_you_global_timeline - Stores data for personalized "For You" feeds
ml.popularity_trending_timeline - Tracks trending posts based on popularity
ml.reply_ranking - Ranks replies for improved display

ml.account_score

Records quality scores for accounts.

Previous was machine_learning.quality_profiles in Lens V2. Quality score used to be [0 - 10000] in V2. In V3, score is rescaled to [0 - 100] with 2 decimal point decision

SELECT * FROM `lens-protocol-mainnet.ml.account_score` LIMIT 1;

Column	Type	Description
account	bytea	Account identifier
score	numeric	Quality score. Ranging from [0 - 100]
generated_at	timestamp with time zone	Score generation time

Back to ML Schema

ml.for_you_global_timeline

Stores data for personalized "For You" feeds.

Previous was machine_learning.for_you_global_feed in Lens V2

SELECT * FROM `lens-protocol-mainnet.ml.for_you_global_timeline` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
account	bytea	Account identifier
rank	integer	Ranking position
source	character varying	Source of ranking
generated_at	timestamp with time zone	Generation time

Back to ML Schema

Tracks trending posts based on popularity.

Previous was machine_learning.popularity_trending_feed in Lens V2

SELECT * FROM `lens-protocol-mainnet.ml.popularity_trending_timeline` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
account	bytea	Account identifier
score	integer	Popularity score
generated_at	timestamp with time zone	Generation time

Back to ML Schema

ml.reply_ranking

Ranks replies for improved display.

Previous was machine_learning.reply_ranking in Lens V2

SELECT * FROM `lens-protocol-mainnet.ml.reply_ranking` LIMIT 1;

Column	Type	Description
parent_post	bytea	Parent post identifier
post	bytea	Reply post identifier
score	integer	Ranking score
generated_at	timestamp with time zone	Generation time

Back to ML Schema

Post Schema

The Post Schema is central to content management in the platform. It handles all aspects of posts including content, metadata, actions, rules, reactions, and mentions. This schema tracks post content, interactions, statistics, and relationships between posts.

SELECT  account as original_account_address,  `lens-protocol-mainnet.post.FORMAT_HEX`(account) as web3_formatted_account_addressFROM `lens-protocol-mainnet.post.record`LIMIT 5;

Post Schema Tables

post.account_mention - Records account mentions in posts
post.action - Records post actions
post.action_config - Stores post action configurations
post.action_executed - Records executed post actions
post.action_executed_by_account_count - Counts actions executed by accounts on posts
post.action_executed_count - Counts actions executed on posts
post.action_metadata - Stores metadata for post actions
post.extra_data - Stores extra data for posts
post.feed_tag_summary - Summarizes post tags by feed
post.group_mention - Records group mentions in posts
post.hashtag - Records hashtags used in posts
post.metadata - Stores post metadata
post.metadata_edited - Records edited post metadata
post.reaction - Records reactions to posts
post.reaction_summary - Summarizes reactions to posts
post.record - Stores post records
post.rule_config - Stores post rule configurations
post.rule_selector - Stores post rule selectors
post.summary - Summarizes post statistics
post.tag - Records tags used in posts
post.tag_summary - Summarizes tag usage
post.universal_action_config - Stores universal action configurations for posts

post.account_mention

Records account mentions in posts.

SELECT * FROM `lens-protocol-mainnet.post.account_mention` LIMIT 1;

Column	Type	Description
mention_id	integer	Unique identifier
post	bytea	Post identifier
account	bytea	Mentioned account
namespace	bytea	Namespace identifier
snapshot_username_used	character varying	Username used in mention
timestamp	timestamp with time zone	Mention time
sequence_id	numeric	Sequence identifier

Back to Post Schema

post.action

Records post actions.

Previous was publication.open_action_module_multirecipient in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.action` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
post	bytea	Post identifier
implementation	bytea	Implementation address
setup_data	text	Setup data
setup_return_data	text	Setup return data
collect_limit	character varying	Collection limit
collect_nft_address	bytea	Collect NFT address
amount	character varying	Action amount
follower_only	boolean	Follower-only restriction
currency	bytea	Currency address
recipients	ARRAY	Recipients list
referral_fee	numeric	Referral fee percentage
end_timestamp	timestamp with time zone	End time
tx_hash	bytea	Transaction hash
block_hash	bytea	Block hash
timestamp	timestamp with time zone	Action time
sequence_id	numeric	Sequence identifier

Back to Post Schema

post.action_config

Stores post action configurations.

SELECT * FROM `lens-protocol-mainnet.post.action_config` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
action_address	bytea	Action address
type	USER-DEFINED	Action type
feed	bytea	Feed identifier
post_id	bytea	Post identifier
setup_by_account	bytea	Setup account
decoded_config_params	jsonb	Decoded config parameters
disabled	boolean	Whether action is disabled
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
disable_extra_data	bytea	Disable extra data
enable_extra_data	bytea	Enable extra data
last_updated_sequence_id	numeric	Last update sequence ID
return_data	bytea	Return data
raw_config_params	jsonb	Raw config parameters
app	bytea	App identifier
collect_nft_address	bytea	Collect NFT address

Back to Post Schema

post.action_executed

Records executed post actions.

SELECT * FROM `lens-protocol-mainnet.post.action_executed` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
action_address	bytea	Action address
type	USER-DEFINED	Action type
feed	bytea	Feed identifier
post_id	bytea	Post identifier
raw_params	bytea	Raw parameters
decoded_params	jsonb	Decoded parameters
timestamp	timestamp with time zone	Execution time
sequence_id	numeric	Sequence identifier
app	bytea	App identifier
account	bytea	Executing account

Back to Post Schema

post.action_executed_by_account_count

Counts actions executed by accounts on posts.

SELECT * FROM `lens-protocol-mainnet.post.action_executed_by_account_count` LIMIT 1;

Column	Type	Description
action_address	bytea	Action address
post_id	bytea	Post identifier
by_account	bytea	Executing account
total	integer	Execution count

Back to Post Schema

post.action_executed_count

Counts actions executed on posts.

SELECT * FROM `lens-protocol-mainnet.post.action_executed_count` LIMIT 1;

Column	Type	Description
action_address	bytea	Action address
post_id	bytea	Post identifier
total	integer	Execution count

Back to Post Schema

post.action_metadata

Stores metadata for post actions.

SELECT * FROM `lens-protocol-mainnet.post.action_metadata` LIMIT 1;

Column	Type	Description
action	bytea	Action identifier
metadata_uri	character varying	Metadata URI
metadata_snapshot_location_url	character varying	Metadata snapshot URL
metadata	jsonb	Stored metadata
name	character varying	Action name
description	character varying	Action description
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to Post Schema

post.extra_data

Stores extra data for posts.

SELECT * FROM `lens-protocol-mainnet.post.extra_data` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
key	bytea	Data key
value	bytea	Data value
post	bytea	Post identifier
block_hash	bytea	Block hash
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
last_updated_sequence_id	numeric	Last update sequence ID
sequence_id	numeric	Sequence identifier

Back to Post Schema

post.feed_tag_summary

Summarizes post tags by feed.

SELECT * FROM `lens-protocol-mainnet.post.feed_tag_summary` LIMIT 1;

Column	Type	Description
tag	character varying	Tag name
feed	bytea	Feed identifier
total	integer	Usage count

Back to Post Schema

post.group_mention

Records group mentions in posts.

SELECT * FROM `lens-protocol-mainnet.post.group_mention` LIMIT 1;

Column	Type	Description
mention_id	integer	Unique identifier
post	bytea	Post identifier
group	bytea	Mentioned group
timestamp	timestamp with time zone	Mention time
sequence_id	numeric	Sequence identifier

Back to Post Schema

post.hashtag

Records hashtags used in posts.

Previous was publication.hashtag in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.hashtag` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
hashtag	character varying	Hashtag text

Back to Post Schema

post.metadata

Stores post metadata.

Previous was publication.metadata in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.metadata` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
metadata_snapshot_location_url	character varying	Metadata snapshot URL
metadata	jsonb	Stored metadata
metadata_version	character	Metadata version
content	text	Post content
content_vector	tsvector	Content vector for search
language	character	Language code
region	character	Region code
content_warning	USER-DEFINED	Content warning type
main_content_focus	USER-DEFINED	Main content focus
tags_vector	tsvector	Tags vector for search
is_encrypted	boolean	Whether content is encrypted
created_at	timestamp with time zone	Creation time
app	bytea	App identifier

Back to Post Schema

post.metadata_edited

Records edited post metadata.

SELECT * FROM `lens-protocol-mainnet.post.metadata_edited` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
post	bytea	Post identifier
metadata_snapshot_location_url	character varying	Metadata snapshot URL
metadata	jsonb	Stored metadata
metadata_version	character	Metadata version
content	text	Edited content
content_vector	tsvector	Content vector for search
language	character	Language code
region	character	Region code
content_warning	USER-DEFINED	Content warning type
main_content_focus	USER-DEFINED	Main content focus
tags_vector	tsvector	Tags vector for search
is_encrypted	boolean	Whether content is encrypted
created_at	timestamp with time zone	Edit time

Back to Post Schema

post.reaction

Records reactions to posts.

Previous was publication.reaction in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.reaction` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
account	bytea	Reacting account
type	USER-DEFINED	Reaction type
action_at	timestamp with time zone	Reaction time
app	bytea	App identifier

Back to Post Schema

post.reaction_summary

Summarizes reactions to posts.

Previous was global_stats.publication_reaction in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.reaction_summary` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
reaction_type	USER-DEFINED	Reaction type
total	integer	Reaction count

Back to Post Schema

post.record

Stores post records.

Previous was publication.record in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.record` LIMIT 1;

Column	Type	Description
id	bytea	Post identifier
feed_local_sequential_id	bytea	Feed sequential ID
legacy_id	character varying	Legacy post ID
feed	bytea	Feed identifier
account	bytea	Author account
content_uri	character varying	Content URI
post_types	JSON	Post types
parent_post	bytea	Parent post
quoted_post	bytea	Quoted post
root_post	bytea	Root post
app	bytea	App identifier
metadata_passed	boolean	Whether metadata passed validation
is_deleted	boolean	Whether post is deleted
is_hidden_by_parent	boolean	Whether hidden by parent
is_edited	boolean	Whether post is edited
block_hash	bytea	Block hash
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Post time
sequence_id	numeric	Sequence identifier
slug	character varying	URL slug

Back to Post Schema

post.rule_config

Stores post rule configurations.

SELECT * FROM `lens-protocol-mainnet.post.rule_config` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
rule_address	bytea	Rule address
config_salt	bytea	Configuration salt
type	USER-DEFINED	Rule type
feed	bytea	Feed identifier
post_id	bytea	Post identifier
raw_config_params	jsonb	Raw config parameters
decoded_config_params	jsonb	Decoded config parameters
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
last_updated_sequence_id	numeric	Last update sequence ID

Back to Post Schema

post.rule_selector

Stores post rule selectors.

SELECT * FROM `lens-protocol-mainnet.post.rule_selector` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
config_salt	bytea	Configuration salt
selector	USER-DEFINED	Rule selector
is_required	boolean	Whether rule is required
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
feed	bytea	Feed identifier
post_id	bytea	Post identifier
rule_address	bytea	Rule address

Back to Post Schema

post.summary

Summarizes post statistics.

Previous was global_stats.publication in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.summary` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
total_amount_of_collects	integer	Total collects
total_amount_of_collects_by_flagged_accounts	integer	Collects by flagged accounts
total_amount_of_acted	integer	Total actions
total_amount_of_acted_by_flagged_accounts	integer	Actions by flagged accounts
total_amount_of_reposts	integer	Total reposts
total_amount_of_reposts_by_flagged_accounts	integer	Reposts by flagged accounts
total_amount_of_comments	integer	Total comments
total_amount_of_comments_by_flagged_accounts	integer	Comments by flagged accounts
total_amount_of_comments_hidden_by_author	integer	Comments hidden by author
total_amount_of_quotes	integer	Total quotes
total_amount_of_quotes_by_flagged_accounts	integer	Quotes by flagged accounts
total_reactions	integer	Total reactions
total_reactions_by_flagged_accounts	integer	Reactions by flagged accounts
total_bookmarks	integer	Total bookmarks
total_bookmarks_by_flagged_accounts	integer	Bookmarks by flagged accounts
total_amount_of_tips	integer	Total tips
total_amount_of_tips_by_flagged_accounts	integer	Tips by flagged accounts

Repost/Mirros are not migrated from Lens V2. Total_reposts may not represent the actual numbers from Lens V2

Back to Post Schema

post.tag

Records tags used in posts.

Previous was publication.tag in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.tag` LIMIT 1;

Column	Type	Description
post	bytea	Post identifier
tag	character varying	Tag text
tag_vector	tsvector	Tag vector for search
timestamp	timestamp with time zone	Tag time
sequence_id	numeric	Sequence identifier

Back to Post Schema

post.tag_summary

Summarizes tag usage.

Previous was global_stats.publication_tag in Lens V2

SELECT * FROM `lens-protocol-mainnet.post.tag_summary` LIMIT 1;

Column	Type	Description
tag	character varying	Tag text
total	integer	Usage count

Back to Post Schema

post.universal_action_config

Stores universal action configurations for posts.

SELECT * FROM `lens-protocol-mainnet.post.universal_action_config` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
action_address	bytea	Action address
type	USER-DEFINED	Action type
raw_config_params	jsonb	Raw config parameters
decoded_config_params	jsonb	Decoded config parameters
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier

Back to Post Schema

Rule Schema

The Rule Schema manages platform rules and their configurations. It tracks rule definitions, configurations, and selectors that determine how rules are applied across different contexts in the platform.

Rule Schema Tables

rule.config - Stores rule configurations
rule.selector - Stores rule selectors

rule.config

Stores rule configurations.

SELECT * FROM `lens-protocol-mainnet.rule.config` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
rule_address	bytea	Rule address
config_salt	bytea	Configuration salt
type	USER-DEFINED	Rule type
primitive	bytea	Primitive address
raw_config_params	jsonb	Raw config parameters
decoded_config_params	jsonb	Decoded config parameters
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
last_updated_sequence_id	numeric	Last update sequence ID

Back to Rule Schema

rule.selector

Stores rule selectors.

SELECT * FROM `lens-protocol-mainnet.rule.selector` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
config_salt	bytea	Configuration salt
selector	USER-DEFINED	Rule selector
is_required	boolean	Whether rule is required
timestamp	timestamp with time zone	Configuration time
sequence_id	numeric	Sequence identifier
primitive	bytea	Primitive address
rule_address	bytea	Rule address

Back to Rule Schema

Sponsorship Schema

The Sponsorship Schema manages sponsor-related data in the platform. It tracks sponsorships, funds, grants, rate limits, signers, and metadata. This schema enables gas-free transactions and financial support mechanisms in the platform.

Sponsorship Schema Tables

sponsorship.exclusive - Records exclusive sponsorships
sponsorship.funds_spent - Records spent sponsorship funds
sponsorship.grant_given - Records sponsorship grants
sponsorship.metadata - Stores sponsorship metadata
sponsorship.rate_limit - Records sponsorship rate limits
sponsorship.record - Stores sponsorship records
sponsorship.signer - Records sponsorship signers

sponsorship.exclusive

Records exclusive sponsorships.

SELECT * FROM `lens-protocol-mainnet.sponsorship.exclusive` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
sponsorship	bytea	Sponsorship identifier
label	character varying	Sponsorship label
address	bytea	Address
tx_hash	bytea	Transaction hash
block_hash	bytea	Block hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to Sponsorship Schema

sponsorship.funds_spent

Records spent sponsorship funds.

SELECT * FROM `lens-protocol-mainnet.sponsorship.funds_spent` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
sponsorship	bytea	Sponsorship identifier
scoped_grant_id	bytea	Grant identifier
amount	bytea	Amount spent
tx_hash	bytea	Transaction hash
block_hash	bytea	Block hash
timestamp	timestamp with time zone	Spending time
sequence_id	numeric	Sequence identifier

Back to Sponsorship Schema

sponsorship.grant_given

Records sponsorship grants.

SELECT * FROM `lens-protocol-mainnet.sponsorship.grant_given` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
sponsorship	bytea	Sponsorship identifier
scoped_grant_id	bytea	Grant identifier
amount	bytea	Grant amount
is_revoke	boolean	Whether grant is revoked
actioned_by	bytea	Account that performed the action
tx_hash	bytea	Transaction hash
block_hash	bytea	Block hash
timestamp	timestamp with time zone	Grant time
sequence_id	numeric	Sequence identifier

Back to Sponsorship Schema

sponsorship.metadata

Stores sponsorship metadata.

SELECT * FROM `lens-protocol-mainnet.sponsorship.metadata` LIMIT 1;

Column	Type	Description
sponsorship	bytea	Sponsorship identifier
metadata_uri	character varying	Metadata URI
metadata_snapshot_location_url	character varying	Metadata snapshot URL
metadata	jsonb	Stored metadata
name	character varying	Sponsorship name
description	character varying	Sponsorship description
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to Sponsorship Schema

sponsorship.rate_limit

Records sponsorship rate limits.

SELECT * FROM `lens-protocol-mainnet.sponsorship.rate_limit` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
sponsorship	bytea	Sponsorship identifier
global_window	USER-DEFINED	Global time window
global_limit	numeric	Global limit
user_window	USER-DEFINED	User time window
user_limit	numeric	User limit
tx_hash	bytea	Transaction hash
block_hash	bytea	Block hash
timestamp	timestamp with time zone	Rate limit time
sequence_id	numeric	Sequence identifier
last_updated_sequence_id	numeric	Last update sequence ID

Back to Sponsorship Schema

sponsorship.record

Stores sponsorship records.

SELECT * FROM `lens-protocol-mainnet.sponsorship.record` LIMIT 1;

Column	Type	Description
sponsorship	bytea	Sponsorship identifier
block_hash	bytea	Block hash
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier
is_paused	boolean	Whether sponsorship is paused
paused_last_updated_sequence_id	numeric	Pause update sequence ID

Back to Sponsorship Schema

sponsorship.signer

Records sponsorship signers.

SELECT * FROM `lens-protocol-mainnet.sponsorship.signer` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
sponsorship	bytea	Sponsorship identifier
label	character varying	Signer label
address	bytea	Signer address
is_lens_backend_signer	boolean	Whether signer is Lens backend
block_hash	bytea	Block hash
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Signer time
sequence_id	numeric	Sequence identifier

Back to Sponsorship Schema

Username Schema

The Username Schema manages username-related data in the platform. It tracks username records, reservations, namespace records, and metadata. This schema ensures unique, human-readable user identifiers across the platform.

Username Schema Tables

username.metadata - Stores username namespace metadata
username.namespace_record - Records username namespaces
username.namespace_record_stats - Records namespace statistics
username.record - Stores username records
username.reserved - Records reserved usernames

username.metadata

Stores username namespace metadata.

SELECT * FROM `lens-protocol-mainnet.username.metadata` LIMIT 1;

Column	Type	Description
namespace	bytea	Namespace identifier
metadata_uri	character varying	Metadata URI
metadata_snapshot_location_url	character varying	Metadata snapshot URL
metadata	jsonb	Stored metadata
name	character varying	Namespace name
description	character varying	Namespace description
metadata_version	character	Metadata version
created_on	timestamp with time zone	Creation time

Back to Username Schema

username.namespace_record

Records username namespaces.

Previous was namespace.record in Lens V2

SELECT * FROM `lens-protocol-mainnet.username.namespace_record` LIMIT 1;

Column	Type	Description
address	bytea	Namespace address
namespace	character varying	Namespace name
block_hash	bytea	Block hash
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to Username Schema

username.namespace_record_stats

Records namespace statistics.

SELECT * FROM `lens-protocol-mainnet.username.namespace_record_stats` LIMIT 1;

Column	Type	Description
namespace	bytea	Namespace identifier
usernames_total	integer	Total usernames count

Back to Username Schema

username.record

Stores username records.

Previous was namespace.handle in Lens V2

SELECT * FROM `lens-protocol-mainnet.username.record` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
namespace	bytea	Namespace identifier
local_name	character varying	Local username
account	bytea	Account address
rule_data	bytea	Rule data
block_hash	bytea	Block hash
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier
is_simple_charset	boolean	Whether simple charset is used
token_id	bytea	Token ID
last_transfer_updated_sequence_id	numeric	Last transfer sequence ID

Back to Username Schema

username.reserved

Records reserved usernames.

SELECT * FROM `lens-protocol-mainnet.username.reserved` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
namespace	bytea	Namespace identifier
local_name	character varying	Reserved username
config_salt	bytea	Configuration salt
block_hash	bytea	Block hash
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Reservation time
sequence_id	numeric	Sequence identifier

Back to Username Schema

Miscellaneous Schema

The Miscellaneous Schema contains tables that don't fit into other categories. It includes currency records, transaction tracking, and extra data storage. These tables support various platform functions that aren't specific to a single domain.

Miscellaneous Schema Tables

currencies.record - Records supported currencies
transaction.known_transactions - Records known transactions
extra_data.record - Stores extra data records

currencies.record

Records supported currencies.

Previous was enabled.currency in Lens V2

SELECT * FROM `lens-protocol-mainnet.currencies.record` LIMIT 1;

Column	Type	Description
currency	bytea	Currency address
name	character varying	Currency name
pretty_name	character varying	Formatted currency name
symbol	character varying	Currency symbol
decimals	integer	Decimal places
verified	boolean	Verification status
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
sequence_id	numeric	Sequence identifier

Back to Miscellaneous Schema

transaction.known_transactions

Records known transactions.

SELECT * FROM `lens-protocol-mainnet.transaction.known_transactions` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
tx_hash	bytea	Transaction hash
indexing_status	USER-DEFINED	Indexing status
failed_reason	character varying	Failure reason
block_hash	bytea	Block hash
block_timestamp	timestamp with time zone	Block timestamp
sequence_id	numeric	Sequence identifier
operation	USER-DEFINED	Operation type
dependencies_operations	JSON	Dependent operations

Back to Miscellaneous Schema

extra_data.record

Stores extra data records.

SELECT * FROM `lens-protocol-mainnet.extra_data.record` LIMIT 1;

Column	Type	Description
id	integer	Unique identifier
key	bytea	Key
value	bytea	Value
primitive	bytea	Primitive
block_hash	bytea	Hash of the block containing this record
tx_hash	bytea	Transaction hash
timestamp	timestamp with time zone	Record time
last_updated_sequence_id	numeric	Last update sequence ID
sequence_id	numeric	Sequence identifier

Back to Miscellaneous Schema