sqlc

type BulkInitializeSourceSyncsParams struct {
	SourceIds    []uuid.UUID  `json:"source_ids"`
	SyncStatuses []SyncStatus `json:"sync_statuses"`
	ErrorMsgs    []string     `json:"error_msgs"`
}

type BulkUpsertConfigSourcesParams struct {
	Names         []string           `json:"names"`
	SourceTypes   []string           `json:"source_types"`
	Formats       []string           `json:"formats"`
	SourceConfigs [][]byte           `json:"source_configs"`
	FilterConfigs [][]byte           `json:"filter_configs"`
	SyncSchedules []pgtypes.Interval `json:"sync_schedules"`
	Syncables     []bool             `json:"syncables"`
	Claims        [][]byte           `json:"claims"`
	CreatedAts    []time.Time        `json:"created_ats"`
	UpdatedAts    []time.Time        `json:"updated_ats"`
}

type BulkUpsertConfigSourcesRow struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type CreationType string

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type DeleteEntryVersionParams struct {
	EntryID uuid.UUID `json:"entry_id"`
	Version string    `json:"version"`
}

type DeleteOrphanedEntryVersionsParams struct {
	SourceID  uuid.UUID   `json:"source_id"`
	EntryType EntryType   `json:"entry_type"`
	KeepIds   []uuid.UUID `json:"keep_ids"`
}

type DeleteRegistryEntryParams struct {
	SourceID  uuid.UUID `json:"source_id"`
	EntryType EntryType `json:"entry_type"`
	Name      string    `json:"name"`
}

type EntryType string

type EntryVersion struct {
	ID          uuid.UUID  `json:"id"`
	EntryID     uuid.UUID  `json:"entry_id"`
	Version     string     `json:"version"`
	Title       *string    `json:"title"`
	Description *string    `json:"description"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
	Name        string     `json:"name"`
}

type GetAPISourcesByNamesRow struct {
	ID           uuid.UUID        `json:"id"`
	Name         string           `json:"name"`
	CreationType CreationType     `json:"creation_type"`
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	Claims       []byte           `json:"claims"`
	CreatedAt    *time.Time       `json:"created_at"`
	UpdatedAt    *time.Time       `json:"updated_at"`
}

type GetLatestEntryVersionParams struct {
	Name     string    `json:"name"`
	SourceID uuid.UUID `json:"source_id"`
}

type GetManagedSourcesRow struct {
	ID           uuid.UUID    `json:"id"`
	Name         string       `json:"name"`
	SourceType   string       `json:"source_type"`
	CreationType CreationType `json:"creation_type"`
	Claims       []byte       `json:"claims"`
	CreatedAt    *time.Time   `json:"created_at"`
	UpdatedAt    *time.Time   `json:"updated_at"`
}

type GetRegistryEntryByNameParams struct {
	SourceID  uuid.UUID `json:"source_id"`
	EntryType EntryType `json:"entry_type"`
	Name      string    `json:"name"`
}

type GetRegistryEntryByNameRow struct {
	ID     uuid.UUID `json:"id"`
	Claims []byte    `json:"claims"`
}

type GetServerIDsByRegistryNameVersionRow struct {
	VersionID uuid.UUID `json:"version_id"`
	Name      string    `json:"name"`
	Version   string    `json:"version"`
}

type GetServerVersionBySourceNameParams struct {
	Name       string `json:"name"`
	Version    string `json:"version"`
	SourceName string `json:"source_name"`
}

type GetServerVersionBySourceNameRow struct {
	RegistryType        string     `json:"registry_type"`
	ID                  uuid.UUID  `json:"id"`
	Name                string     `json:"name"`
	Version             string     `json:"version"`
	IsLatest            bool       `json:"is_latest"`
	CreatedAt           *time.Time `json:"created_at"`
	UpdatedAt           *time.Time `json:"updated_at"`
	Description         *string    `json:"description"`
	Title               *string    `json:"title"`
	Website             *string    `json:"website"`
	UpstreamMeta        []byte     `json:"upstream_meta"`
	ServerMeta          []byte     `json:"server_meta"`
	RepositoryUrl       *string    `json:"repository_url"`
	RepositoryID        *string    `json:"repository_id"`
	RepositorySubfolder *string    `json:"repository_subfolder"`
	RepositoryType      *string    `json:"repository_type"`
	Claims              []byte     `json:"claims"`
	Position            int32      `json:"position"`
}

type GetServerVersionParams struct {
	RegistryID     uuid.UUID   `json:"registry_id"`
	Name           string      `json:"name"`
	Version        string      `json:"version"`
	SourceName     *string     `json:"source_name"`
	CursorPosition pgtype.Int4 `json:"cursor_position"`
	CursorSourceID *uuid.UUID  `json:"cursor_source_id"`
	Size           int64       `json:"size"`
}

type GetServerVersionRow struct {
	RegistryType        string     `json:"registry_type"`
	ID                  uuid.UUID  `json:"id"`
	Name                string     `json:"name"`
	Version             string     `json:"version"`
	IsLatest            bool       `json:"is_latest"`
	CreatedAt           *time.Time `json:"created_at"`
	UpdatedAt           *time.Time `json:"updated_at"`
	Description         *string    `json:"description"`
	Title               *string    `json:"title"`
	Website             *string    `json:"website"`
	UpstreamMeta        []byte     `json:"upstream_meta"`
	ServerMeta          []byte     `json:"server_meta"`
	RepositoryUrl       *string    `json:"repository_url"`
	RepositoryID        *string    `json:"repository_id"`
	RepositorySubfolder *string    `json:"repository_subfolder"`
	RepositoryType      *string    `json:"repository_type"`
	Claims              []byte     `json:"claims"`
	SourceID            uuid.UUID  `json:"source_id"`
	Position            int32      `json:"position"`
}

type GetSkillVersionBySourceNameParams struct {
	Name       string `json:"name"`
	Version    string `json:"version"`
	SourceName string `json:"source_name"`
}

type GetSkillVersionBySourceNameRow struct {
	RegistryType   string      `json:"registry_type"`
	ID             uuid.UUID   `json:"id"`
	Name           string      `json:"name"`
	Version        string      `json:"version"`
	IsLatest       bool        `json:"is_latest"`
	CreatedAt      *time.Time  `json:"created_at"`
	UpdatedAt      *time.Time  `json:"updated_at"`
	Description    *string     `json:"description"`
	Title          *string     `json:"title"`
	SkillVersionID uuid.UUID   `json:"skill_version_id"`
	Namespace      string      `json:"namespace"`
	Status         SkillStatus `json:"status"`
	License        *string     `json:"license"`
	Compatibility  *string     `json:"compatibility"`
	AllowedTools   []string    `json:"allowed_tools"`
	Repository     []byte      `json:"repository"`
	Icons          []byte      `json:"icons"`
	Metadata       []byte      `json:"metadata"`
	ExtensionMeta  []byte      `json:"extension_meta"`
	Claims         []byte      `json:"claims"`
	Position       int32       `json:"position"`
}

type GetSkillVersionParams struct {
	RegistryID     uuid.UUID   `json:"registry_id"`
	Name           string      `json:"name"`
	Version        string      `json:"version"`
	SourceName     *string     `json:"source_name"`
	Namespace      *string     `json:"namespace"`
	CursorPosition pgtype.Int4 `json:"cursor_position"`
	CursorSourceID *uuid.UUID  `json:"cursor_source_id"`
	Size           int64       `json:"size"`
}

type GetSkillVersionRow struct {
	RegistryType   string      `json:"registry_type"`
	ID             uuid.UUID   `json:"id"`
	Name           string      `json:"name"`
	Version        string      `json:"version"`
	IsLatest       bool        `json:"is_latest"`
	CreatedAt      *time.Time  `json:"created_at"`
	UpdatedAt      *time.Time  `json:"updated_at"`
	Description    *string     `json:"description"`
	Title          *string     `json:"title"`
	SkillVersionID uuid.UUID   `json:"skill_version_id"`
	Namespace      string      `json:"namespace"`
	Status         SkillStatus `json:"status"`
	License        *string     `json:"license"`
	Compatibility  *string     `json:"compatibility"`
	AllowedTools   []string    `json:"allowed_tools"`
	Repository     []byte      `json:"repository"`
	Icons          []byte      `json:"icons"`
	Metadata       []byte      `json:"metadata"`
	ExtensionMeta  []byte      `json:"extension_meta"`
	Claims         []byte      `json:"claims"`
	SourceID       uuid.UUID   `json:"source_id"`
	Position       int32       `json:"position"`
}

type GetSourceByNameRow struct {
	ID           uuid.UUID        `json:"id"`
	Name         string           `json:"name"`
	CreationType CreationType     `json:"creation_type"`
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	Claims       []byte           `json:"claims"`
	CreatedAt    *time.Time       `json:"created_at"`
	UpdatedAt    *time.Time       `json:"updated_at"`
}

type GetSourceRow struct {
	ID           uuid.UUID        `json:"id"`
	Name         string           `json:"name"`
	CreationType CreationType     `json:"creation_type"`
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	Claims       []byte           `json:"claims"`
	CreatedAt    *time.Time       `json:"created_at"`
	UpdatedAt    *time.Time       `json:"updated_at"`
}

type IconTheme string

type InitializeSourceSyncParams struct {
	Name       string     `json:"name"`
	SyncStatus SyncStatus `json:"sync_status"`
	ErrorMsg   *string    `json:"error_msg"`
}

type InsertEntryVersionParams struct {
	EntryID     uuid.UUID  `json:"entry_id"`
	Name        string     `json:"name"`
	Version     string     `json:"version"`
	Title       *string    `json:"title"`
	Description *string    `json:"description"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
}

type InsertRegistryEntryParams struct {
	SourceID  uuid.UUID  `json:"source_id"`
	EntryType EntryType  `json:"entry_type"`
	Name      string     `json:"name"`
	Claims    []byte     `json:"claims"`
	CreatedAt *time.Time `json:"created_at"`
	UpdatedAt *time.Time `json:"updated_at"`
}

type InsertServerIconParams struct {
	ServerID  uuid.UUID `json:"server_id"`
	SourceUri string    `json:"source_uri"`
	MimeType  string    `json:"mime_type"`
	Theme     IconTheme `json:"theme"`
}

type InsertServerPackageParams struct {
	ServerID         uuid.UUID `json:"server_id"`
	RegistryType     string    `json:"registry_type"`
	PkgRegistryUrl   string    `json:"pkg_registry_url"`
	PkgIdentifier    string    `json:"pkg_identifier"`
	PkgVersion       string    `json:"pkg_version"`
	RuntimeHint      *string   `json:"runtime_hint"`
	RuntimeArguments []string  `json:"runtime_arguments"`
	PackageArguments []string  `json:"package_arguments"`
	EnvVars          []byte    `json:"env_vars"`
	Sha256Hash       *string   `json:"sha256_hash"`
	Transport        string    `json:"transport"`
	TransportUrl     *string   `json:"transport_url"`
	TransportHeaders []byte    `json:"transport_headers"`
}

type InsertServerRemoteParams struct {
	ServerID         uuid.UUID `json:"server_id"`
	Transport        string    `json:"transport"`
	TransportUrl     string    `json:"transport_url"`
	TransportHeaders []byte    `json:"transport_headers"`
}

type InsertServerVersionForSyncParams struct {
	VersionID           uuid.UUID `json:"version_id"`
	Website             *string   `json:"website"`
	UpstreamMeta        []byte    `json:"upstream_meta"`
	ServerMeta          []byte    `json:"server_meta"`
	RepositoryUrl       *string   `json:"repository_url"`
	RepositoryID        *string   `json:"repository_id"`
	RepositorySubfolder *string   `json:"repository_subfolder"`
	RepositoryType      *string   `json:"repository_type"`
}

type InsertServerVersionParams struct {
	VersionID           uuid.UUID `json:"version_id"`
	Website             *string   `json:"website"`
	UpstreamMeta        []byte    `json:"upstream_meta"`
	ServerMeta          []byte    `json:"server_meta"`
	RepositoryUrl       *string   `json:"repository_url"`
	RepositoryID        *string   `json:"repository_id"`
	RepositorySubfolder *string   `json:"repository_subfolder"`
	RepositoryType      *string   `json:"repository_type"`
}

type InsertSkillGitPackageParams struct {
	SkillID   uuid.UUID `json:"skill_id"`
	Url       string    `json:"url"`
	Ref       *string   `json:"ref"`
	CommitSha *string   `json:"commit_sha"`
	Subfolder *string   `json:"subfolder"`
}

type InsertSkillOciPackageParams struct {
	SkillID    uuid.UUID `json:"skill_id"`
	Identifier string    `json:"identifier"`
	Digest     *string   `json:"digest"`
	MediaType  *string   `json:"media_type"`
}

type InsertSkillVersionForSyncParams struct {
	VersionID     uuid.UUID       `json:"version_id"`
	Namespace     string          `json:"namespace"`
	Status        NullSkillStatus `json:"status"`
	License       *string         `json:"license"`
	Compatibility *string         `json:"compatibility"`
	AllowedTools  []string        `json:"allowed_tools"`
	Repository    []byte          `json:"repository"`
	Icons         []byte          `json:"icons"`
	Metadata      []byte          `json:"metadata"`
	ExtensionMeta []byte          `json:"extension_meta"`
}

type InsertSkillVersionParams struct {
	VersionID     uuid.UUID       `json:"version_id"`
	Namespace     string          `json:"namespace"`
	Status        NullSkillStatus `json:"status"`
	License       *string         `json:"license"`
	Compatibility *string         `json:"compatibility"`
	AllowedTools  []string        `json:"allowed_tools"`
	Repository    []byte          `json:"repository"`
	Icons         []byte          `json:"icons"`
	Metadata      []byte          `json:"metadata"`
	ExtensionMeta []byte          `json:"extension_meta"`
}

type InsertSourceParams struct {
	Name         string           `json:"name"`
	CreationType CreationType     `json:"creation_type"`
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	Syncable     bool             `json:"syncable"`
	Claims       []byte           `json:"claims"`
	CreatedAt    *time.Time       `json:"created_at"`
	UpdatedAt    *time.Time       `json:"updated_at"`
}

type InsertSourceSyncParams struct {
	SourceID   *uuid.UUID `json:"source_id"`
	SyncStatus SyncStatus `json:"sync_status"`
	ErrorMsg   *string    `json:"error_msg"`
	StartedAt  *time.Time `json:"started_at"`
}

type LatestEntryVersion struct {
	SourceID        uuid.UUID `json:"source_id"`
	Name            string    `json:"name"`
	Version         string    `json:"version"`
	LatestVersionID uuid.UUID `json:"latest_version_id"`
}

type LinkRegistrySourceParams struct {
	RegistryID uuid.UUID `json:"registry_id"`
	SourceID   uuid.UUID `json:"source_id"`
	Position   int32     `json:"position"`
}

type ListEntriesByRegistryRow struct {
	EntryType  EntryType `json:"entry_type"`
	Name       string    `json:"name"`
	Version    string    `json:"version"`
	SourceName string    `json:"source_name"`
	Position   int32     `json:"position"`
}

type ListEntriesBySourceRow struct {
	EntryType   EntryType  `json:"entry_type"`
	Name        string     `json:"name"`
	Claims      []byte     `json:"claims"`
	Version     string     `json:"version"`
	Title       *string    `json:"title"`
	Description *string    `json:"description"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
}

type ListEntryVersionsRow struct {
	ID      uuid.UUID `json:"id"`
	Version string    `json:"version"`
}

type ListRegistriesParams struct {
	Cursor *string `json:"cursor"`
	Size   int64   `json:"size"`
}

type ListRegistrySourcesRow struct {
	ID   uuid.UUID `json:"id"`
	Name string    `json:"name"`
}

type ListServerPackagesRow struct {
	ServerID         uuid.UUID `json:"server_id"`
	RegistryType     string    `json:"registry_type"`
	PkgRegistryUrl   string    `json:"pkg_registry_url"`
	PkgIdentifier    string    `json:"pkg_identifier"`
	PkgVersion       string    `json:"pkg_version"`
	RuntimeHint      *string   `json:"runtime_hint"`
	RuntimeArguments []string  `json:"runtime_arguments"`
	PackageArguments []string  `json:"package_arguments"`
	EnvVars          []byte    `json:"env_vars"`
	Sha256Hash       *string   `json:"sha256_hash"`
	Transport        string    `json:"transport"`
	TransportUrl     *string   `json:"transport_url"`
	TransportHeaders []byte    `json:"transport_headers"`
}

type ListServersParams struct {
	RegistryID    uuid.UUID  `json:"registry_id"`
	Name          *string    `json:"name"`
	Search        *string    `json:"search"`
	UpdatedSince  *time.Time `json:"updated_since"`
	CursorName    *string    `json:"cursor_name"`
	CursorVersion *string    `json:"cursor_version"`
	Version       *string    `json:"version"`
	Size          int64      `json:"size"`
}

type ListServersRow struct {
	RegistryType        string     `json:"registry_type"`
	ID                  uuid.UUID  `json:"id"`
	Name                string     `json:"name"`
	Version             string     `json:"version"`
	IsLatest            bool       `json:"is_latest"`
	CreatedAt           *time.Time `json:"created_at"`
	UpdatedAt           *time.Time `json:"updated_at"`
	Description         *string    `json:"description"`
	Title               *string    `json:"title"`
	Website             *string    `json:"website"`
	UpstreamMeta        []byte     `json:"upstream_meta"`
	ServerMeta          []byte     `json:"server_meta"`
	RepositoryUrl       *string    `json:"repository_url"`
	RepositoryID        *string    `json:"repository_id"`
	RepositorySubfolder *string    `json:"repository_subfolder"`
	RepositoryType      *string    `json:"repository_type"`
	Claims              []byte     `json:"claims"`
	Position            int32      `json:"position"`
}

type ListSkillsParams struct {
	RegistryID    uuid.UUID  `json:"registry_id"`
	Namespace     *string    `json:"namespace"`
	Name          *string    `json:"name"`
	Search        *string    `json:"search"`
	UpdatedSince  *time.Time `json:"updated_since"`
	CursorName    *string    `json:"cursor_name"`
	CursorVersion *string    `json:"cursor_version"`
	Size          int64      `json:"size"`
}

type ListSkillsRow struct {
	RegistryType  string      `json:"registry_type"`
	VersionID     uuid.UUID   `json:"version_id"`
	Name          string      `json:"name"`
	Version       string      `json:"version"`
	IsLatest      bool        `json:"is_latest"`
	CreatedAt     *time.Time  `json:"created_at"`
	UpdatedAt     *time.Time  `json:"updated_at"`
	Description   *string     `json:"description"`
	Title         *string     `json:"title"`
	Namespace     string      `json:"namespace"`
	Status        SkillStatus `json:"status"`
	License       *string     `json:"license"`
	Compatibility *string     `json:"compatibility"`
	AllowedTools  []string    `json:"allowed_tools"`
	Repository    []byte      `json:"repository"`
	Icons         []byte      `json:"icons"`
	Metadata      []byte      `json:"metadata"`
	ExtensionMeta []byte      `json:"extension_meta"`
	Claims        []byte      `json:"claims"`
	Position      int32       `json:"position"`
}

type ListSourceSyncsByLastUpdateRow struct {
	Name                  string           `json:"name"`
	ID                    uuid.UUID        `json:"id"`
	SourceID              *uuid.UUID       `json:"source_id"`
	SyncStatus            SyncStatus       `json:"sync_status"`
	ErrorMsg              *string          `json:"error_msg"`
	StartedAt             *time.Time       `json:"started_at"`
	EndedAt               *time.Time       `json:"ended_at"`
	AttemptCount          int64            `json:"attempt_count"`
	LastSyncHash          *string          `json:"last_sync_hash"`
	LastAppliedFilterHash *string          `json:"last_applied_filter_hash"`
	ServerCount           int64            `json:"server_count"`
	SkillCount            int64            `json:"skill_count"`
	SyncSchedule          pgtypes.Interval `json:"sync_schedule"`
}

type ListSourceSyncsRow struct {
	Name                  string           `json:"name"`
	ID                    uuid.UUID        `json:"id"`
	SourceID              *uuid.UUID       `json:"source_id"`
	SyncStatus            SyncStatus       `json:"sync_status"`
	ErrorMsg              *string          `json:"error_msg"`
	StartedAt             *time.Time       `json:"started_at"`
	EndedAt               *time.Time       `json:"ended_at"`
	AttemptCount          int64            `json:"attempt_count"`
	LastSyncHash          *string          `json:"last_sync_hash"`
	LastAppliedFilterHash *string          `json:"last_applied_filter_hash"`
	ServerCount           int64            `json:"server_count"`
	SkillCount            int64            `json:"skill_count"`
	SyncSchedule          pgtypes.Interval `json:"sync_schedule"`
}

type ListSourcesParams struct {
	Next *time.Time `json:"next"`
	Prev *time.Time `json:"prev"`
	Size int64      `json:"size"`
}

type ListSourcesRow struct {
	ID           uuid.UUID        `json:"id"`
	Name         string           `json:"name"`
	CreationType CreationType     `json:"creation_type"`
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	Claims       []byte           `json:"claims"`
	CreatedAt    *time.Time       `json:"created_at"`
	UpdatedAt    *time.Time       `json:"updated_at"`
}

type McpServer struct {
	Website             *string   `json:"website"`
	UpstreamMeta        []byte    `json:"upstream_meta"`
	ServerMeta          []byte    `json:"server_meta"`
	RepositoryUrl       *string   `json:"repository_url"`
	RepositoryID        *string   `json:"repository_id"`
	RepositorySubfolder *string   `json:"repository_subfolder"`
	RepositoryType      *string   `json:"repository_type"`
	VersionID           uuid.UUID `json:"version_id"`
}

type McpServerIcon struct {
	ServerID  uuid.UUID `json:"server_id"`
	SourceUri string    `json:"source_uri"`
	MimeType  string    `json:"mime_type"`
	Theme     IconTheme `json:"theme"`
}

type McpServerPackage struct {
	ServerID         uuid.UUID `json:"server_id"`
	RegistryType     string    `json:"registry_type"`
	PkgRegistryUrl   string    `json:"pkg_registry_url"`
	PkgIdentifier    string    `json:"pkg_identifier"`
	PkgVersion       string    `json:"pkg_version"`
	RuntimeHint      *string   `json:"runtime_hint"`
	RuntimeArguments []string  `json:"runtime_arguments"`
	PackageArguments []string  `json:"package_arguments"`
	Sha256Hash       *string   `json:"sha256_hash"`
	Transport        string    `json:"transport"`
	TransportUrl     *string   `json:"transport_url"`
	EnvVars          []byte    `json:"env_vars"`
	TransportHeaders []byte    `json:"transport_headers"`
}

type McpServerRemote struct {
	ServerID         uuid.UUID `json:"server_id"`
	Transport        string    `json:"transport"`
	TransportUrl     string    `json:"transport_url"`
	TransportHeaders []byte    `json:"transport_headers"`
}

type NullCreationType struct {
	CreationType CreationType `json:"creation_type"`
	Valid        bool         `json:"valid"` // Valid is true if CreationType is not NULL
}

type NullEntryType struct {
	EntryType EntryType `json:"entry_type"`
	Valid     bool      `json:"valid"` // Valid is true if EntryType is not NULL
}

type NullIconTheme struct {
	IconTheme IconTheme `json:"icon_theme"`
	Valid     bool      `json:"valid"` // Valid is true if IconTheme is not NULL
}

type NullSkillStatus struct {
	SkillStatus SkillStatus `json:"skill_status"`
	Valid       bool        `json:"valid"` // Valid is true if SkillStatus is not NULL
}

type NullSyncStatus struct {
	SyncStatus SyncStatus `json:"sync_status"`
	Valid      bool       `json:"valid"` // Valid is true if SyncStatus is not NULL
}

type PropagateSourceClaimsToEntriesParams struct {
	Claims   []byte    `json:"claims"`
	SourceID uuid.UUID `json:"source_id"`
}

type Querier interface {
	BulkInitializeSourceSyncs(ctx context.Context, arg BulkInitializeSourceSyncsParams) error
	// Bulk insert or update CONFIG sources (only updates existing CONFIG sources)
	BulkUpsertConfigSources(ctx context.Context, arg BulkUpsertConfigSourcesParams) ([]BulkUpsertConfigSourcesRow, error)
	CountEntryVersions(ctx context.Context, entryID uuid.UUID) (int64, error)
	// Count how many registries reference a given source (via registry_source junction).
	CountRegistriesBySourceID(ctx context.Context, sourceID uuid.UUID) (int64, error)
	// Temp Entry Version Table Operations
	CreateTempEntryVersionTable(ctx context.Context) error
	// Temp Icon Table Operations
	CreateTempIconTable(ctx context.Context) error
	// Temp Package Table Operations
	CreateTempPackageTable(ctx context.Context) error
	// Temporary table operations for bulk sync
	// Note: These queries reference temp tables that don't exist in the schema.
	// sqlc cannot validate these, but we organize them here for maintainability.
	// Temp Server Table Operations
	CreateTempRegistryEntryTable(ctx context.Context) error
	// Temp Remote Table Operations
	CreateTempRemoteTable(ctx context.Context) error
	// Temp Server Table Operations
	CreateTempServerTable(ctx context.Context) error
	// Delete CONFIG registry rows whose names are not in the provided list.
	// Used during config sync to clean up registry/junction rows before deleting orphaned sources.
	DeleteConfigRegistriesNotInList(ctx context.Context, keepNames []string) error
	// Delete CONFIG sources not in the provided list (for config file sync)
	DeleteConfigSourcesNotInList(ctx context.Context, ids []uuid.UUID) error
	DeleteEntryVersion(ctx context.Context, arg DeleteEntryVersionParams) (int64, error)
	DeleteOrphanedEntryVersions(ctx context.Context, arg DeleteOrphanedEntryVersionsParams) error
	DeleteOrphanedIcons(ctx context.Context, serverIds []uuid.UUID) error
	DeleteOrphanedPackages(ctx context.Context, serverIds []uuid.UUID) error
	DeleteOrphanedRemotes(ctx context.Context, serverIds []uuid.UUID) error
	// Delete a registry by name. Go callers guard against deleting wrong creation_type.
	DeleteRegistry(ctx context.Context, name string) (int64, error)
	DeleteRegistryEntry(ctx context.Context, arg DeleteRegistryEntryParams) (int64, error)
	DeleteRegistryEntryByID(ctx context.Context, id uuid.UUID) (int64, error)
	DeleteServerIconsByServerId(ctx context.Context, serverID uuid.UUID) error
	DeleteServerPackagesByServerId(ctx context.Context, serverID uuid.UUID) error
	DeleteServerRemotesByServerId(ctx context.Context, serverID uuid.UUID) error
	DeleteServersByRegistry(ctx context.Context, sourceID uuid.UUID) error
	DeleteSkillGitPackagesBySkillId(ctx context.Context, skillID uuid.UUID) error
	DeleteSkillOciPackagesBySkillId(ctx context.Context, skillID uuid.UUID) error
	DeleteSkillsByRegistry(ctx context.Context, sourceID uuid.UUID) error
	// Delete a source by name. Go callers guard against deleting wrong creation_type.
	DeleteSource(ctx context.Context, name string) (int64, error)
	DropTempEntryVersionTable(ctx context.Context) error
	DropTempRegistryEntryTable(ctx context.Context) error
	GetAPISourcesByNames(ctx context.Context, names []string) ([]GetAPISourcesByNamesRow, error)
	GetLatestEntryVersion(ctx context.Context, arg GetLatestEntryVersionParams) (string, error)
	GetManagedSources(ctx context.Context) ([]GetManagedSourcesRow, error)
	GetRegistryByName(ctx context.Context, name string) (Registry, error)
	GetRegistryEntryByName(ctx context.Context, arg GetRegistryEntryByNameParams) (GetRegistryEntryByNameRow, error)
	GetServerIDsByRegistryNameVersion(ctx context.Context, sourceID uuid.UUID) ([]GetServerIDsByRegistryNameVersionRow, error)
	// Despite the name, this query returns multiple rows. The actual number of
	// records is bounded by the number of sources that provide the same name and
	// version, which we currently don't expect to be more than a few.
	// Cursor-based pagination using (position, source_id) compound cursor.
	// position is the sort key but may not be unique; source_id is the tiebreaker.
	GetServerVersion(ctx context.Context, arg GetServerVersionParams) ([]GetServerVersionRow, error)
	// Source-scoped variant of GetServerVersion used by the publish fetch-back path.
	// source_name and version are required; registry filtering is not applied.
	GetServerVersionBySourceName(ctx context.Context, arg GetServerVersionBySourceNameParams) (GetServerVersionBySourceNameRow, error)
	// Despite the name, this query returns multiple rows. The actual number of
	// records is bounded by the number of sources that provide the same name and
	// version, which we currently don't expect to be more than a few.
	// Cursor-based pagination using (position, source_id) compound cursor.
	// position is the sort key but may not be unique; source_id is the tiebreaker.
	GetSkillVersion(ctx context.Context, arg GetSkillVersionParams) ([]GetSkillVersionRow, error)
	// Source-scoped variant of GetSkillVersion used by the publish fetch-back path.
	// source_name and version are required; registry filtering is not applied.
	GetSkillVersionBySourceName(ctx context.Context, arg GetSkillVersionBySourceNameParams) (GetSkillVersionBySourceNameRow, error)
	GetSource(ctx context.Context, id uuid.UUID) (GetSourceRow, error)
	GetSourceByName(ctx context.Context, name string) (GetSourceByNameRow, error)
	GetSourceSync(ctx context.Context, id uuid.UUID) (RegistrySync, error)
	GetSourceSyncByName(ctx context.Context, name string) (RegistrySync, error)
	InitializeSourceSync(ctx context.Context, arg InitializeSourceSyncParams) error
	InsertEntryVersion(ctx context.Context, arg InsertEntryVersionParams) (uuid.UUID, error)
	InsertRegistryEntry(ctx context.Context, arg InsertRegistryEntryParams) (uuid.UUID, error)
	InsertServerIcon(ctx context.Context, arg InsertServerIconParams) error
	// TODO: this seems unused
	InsertServerPackage(ctx context.Context, arg InsertServerPackageParams) error
	InsertServerRemote(ctx context.Context, arg InsertServerRemoteParams) error
	InsertServerVersion(ctx context.Context, arg InsertServerVersionParams) (uuid.UUID, error)
	InsertServerVersionForSync(ctx context.Context, arg InsertServerVersionForSyncParams) (uuid.UUID, error)
	InsertSkillGitPackage(ctx context.Context, arg InsertSkillGitPackageParams) error
	InsertSkillOciPackage(ctx context.Context, arg InsertSkillOciPackageParams) error
	InsertSkillVersion(ctx context.Context, arg InsertSkillVersionParams) (uuid.UUID, error)
	InsertSkillVersionForSync(ctx context.Context, arg InsertSkillVersionForSyncParams) (uuid.UUID, error)
	// ============================================================================
	// Source Queries (unified, creation_type guards are in Go)
	// ============================================================================
	// Insert a new source with full configuration. creation_type is passed as a parameter.
	InsertSource(ctx context.Context, arg InsertSourceParams) (Source, error)
	InsertSourceSync(ctx context.Context, arg InsertSourceSyncParams) (uuid.UUID, error)
	LinkRegistrySource(ctx context.Context, arg LinkRegistrySourceParams) error
	ListAllSourceNames(ctx context.Context) ([]string, error)
	ListEntriesByRegistry(ctx context.Context, registryID uuid.UUID) ([]ListEntriesByRegistryRow, error)
	ListEntriesBySource(ctx context.Context, sourceID uuid.UUID) ([]ListEntriesBySourceRow, error)
	ListEntryVersions(ctx context.Context, entryID uuid.UUID) ([]ListEntryVersionsRow, error)
	// Queries for the new lightweight registry table and registry_source junction.
	ListRegistries(ctx context.Context, arg ListRegistriesParams) ([]Registry, error)
	ListRegistrySources(ctx context.Context, registryID uuid.UUID) ([]ListRegistrySourcesRow, error)
	ListServerPackages(ctx context.Context, versionIds []uuid.UUID) ([]ListServerPackagesRow, error)
	ListServerRemotes(ctx context.Context, versionIds []uuid.UUID) ([]McpServerRemote, error)
	// Cursor-based pagination using (name, version) compound cursor.
	// The cursor_name and cursor_version parameters define the starting point.
	// When cursor is provided, results start AFTER the specified (name, version) tuple.
	// Returns position from registry_source for source priority ordering.
	// When name is provided, results are filtered to versions of that specific server.
	ListServers(ctx context.Context, arg ListServersParams) ([]ListServersRow, error)
	ListSkillGitPackages(ctx context.Context, versionIds []uuid.UUID) ([]SkillGitPackage, error)
	ListSkillOciPackages(ctx context.Context, versionIds []uuid.UUID) ([]SkillOciPackage, error)
	// Cursor-based pagination using (name, version) compound cursor.
	// The cursor_name and cursor_version parameters define the starting point.
	// When cursor is provided, results start AFTER the specified (name, version) tuple.
	// Returns position from registry_source for source priority ordering.
	ListSkills(ctx context.Context, arg ListSkillsParams) ([]ListSkillsRow, error)
	ListSourceSyncs(ctx context.Context) ([]ListSourceSyncsRow, error)
	ListSourceSyncsByLastUpdate(ctx context.Context) ([]ListSourceSyncsByLastUpdateRow, error)
	ListSources(ctx context.Context, arg ListSourcesParams) ([]ListSourcesRow, error)
	// Update all registry entries for a source to match the source's current claims.
	// Used during initialization to fix drift when source claims change without data change.
	PropagateSourceClaimsToEntries(ctx context.Context, arg PropagateSourceClaimsToEntriesParams) error
	UnlinkAllRegistrySources(ctx context.Context, registryID uuid.UUID) error
	UnlinkRegistrySource(ctx context.Context, arg UnlinkRegistrySourceParams) error
	// Update an existing source. Go callers guard against modifying wrong creation_type.
	UpdateSource(ctx context.Context, arg UpdateSourceParams) (Source, error)
	UpdateSourceSync(ctx context.Context, arg UpdateSourceSyncParams) error
	UpdateSourceSyncStatusByName(ctx context.Context, arg UpdateSourceSyncStatusByNameParams) error
	UpsertEntryVersionsFromTemp(ctx context.Context) ([]UpsertEntryVersionsFromTempRow, error)
	UpsertIconsFromTemp(ctx context.Context) error
	UpsertLatestServerVersion(ctx context.Context, arg UpsertLatestServerVersionParams) (uuid.UUID, error)
	UpsertLatestSkillVersion(ctx context.Context, arg UpsertLatestSkillVersionParams) (uuid.UUID, error)
	UpsertPackagesFromTemp(ctx context.Context) error
	// Insert or update a registry. The creation_type is passed as a parameter.
	// Business logic in Go guards against cross-type overwrites.
	UpsertRegistry(ctx context.Context, arg UpsertRegistryParams) (Registry, error)
	UpsertRegistryEntriesFromTemp(ctx context.Context) ([]UpsertRegistryEntriesFromTempRow, error)
	UpsertRemotesFromTemp(ctx context.Context) error
	UpsertServerVersionForSync(ctx context.Context, arg UpsertServerVersionForSyncParams) (uuid.UUID, error)
	UpsertServersFromTemp(ctx context.Context) error
	UpsertSkillVersionForSync(ctx context.Context, arg UpsertSkillVersionForSyncParams) (uuid.UUID, error)
	// ============================================================================
	// CONFIG Source Queries (only operate on creation_type='CONFIG')
	// ============================================================================
	// Insert or update a source. The creation_type is passed as a parameter.
	// Business logic in Go guards against cross-type overwrites.
	UpsertSource(ctx context.Context, arg UpsertSourceParams) (uuid.UUID, error)
	UpsertSourceSyncByName(ctx context.Context, arg UpsertSourceSyncByNameParams) error
}

type Queries struct {
	// contains filtered or unexported fields
}

type Registry struct {
	ID           uuid.UUID    `json:"id"`
	Name         string       `json:"name"`
	Claims       []byte       `json:"claims"`
	CreationType CreationType `json:"creation_type"`
	CreatedAt    *time.Time   `json:"created_at"`
	UpdatedAt    *time.Time   `json:"updated_at"`
}

type RegistryEntry struct {
	ID        uuid.UUID  `json:"id"`
	SourceID  uuid.UUID  `json:"source_id"`
	EntryType EntryType  `json:"entry_type"`
	Name      string     `json:"name"`
	CreatedAt *time.Time `json:"created_at"`
	UpdatedAt *time.Time `json:"updated_at"`
	Claims    []byte     `json:"claims"`
}

type RegistrySource struct {
	RegistryID uuid.UUID  `json:"registry_id"`
	SourceID   uuid.UUID  `json:"source_id"`
	Position   int32      `json:"position"`
	CreatedAt  *time.Time `json:"created_at"`
}

type RegistrySync struct {
	ID                    uuid.UUID  `json:"id"`
	SourceID              *uuid.UUID `json:"source_id"`
	SyncStatus            SyncStatus `json:"sync_status"`
	ErrorMsg              *string    `json:"error_msg"`
	StartedAt             *time.Time `json:"started_at"`
	EndedAt               *time.Time `json:"ended_at"`
	AttemptCount          int64      `json:"attempt_count"`
	LastSyncHash          *string    `json:"last_sync_hash"`
	LastAppliedFilterHash *string    `json:"last_applied_filter_hash"`
	ServerCount           int64      `json:"server_count"`
	SkillCount            int64      `json:"skill_count"`
}

type Skill struct {
	VersionID     uuid.UUID   `json:"version_id"`
	Namespace     string      `json:"namespace"`
	Status        SkillStatus `json:"status"`
	License       *string     `json:"license"`
	Compatibility *string     `json:"compatibility"`
	AllowedTools  []string    `json:"allowed_tools"`
	Repository    []byte      `json:"repository"`
	Icons         []byte      `json:"icons"`
	Metadata      []byte      `json:"metadata"`
	ExtensionMeta []byte      `json:"extension_meta"`
}

type SkillGitPackage struct {
	ID        uuid.UUID `json:"id"`
	SkillID   uuid.UUID `json:"skill_id"`
	Url       string    `json:"url"`
	Ref       *string   `json:"ref"`
	CommitSha *string   `json:"commit_sha"`
	Subfolder *string   `json:"subfolder"`
}

type SkillOciPackage struct {
	ID         uuid.UUID `json:"id"`
	SkillID    uuid.UUID `json:"skill_id"`
	Identifier string    `json:"identifier"`
	Digest     *string   `json:"digest"`
	MediaType  *string   `json:"media_type"`
}

type SkillStatus string

type Source struct {
	ID           uuid.UUID        `json:"id"`
	Name         string           `json:"name"`
	CreatedAt    *time.Time       `json:"created_at"`
	UpdatedAt    *time.Time       `json:"updated_at"`
	CreationType CreationType     `json:"creation_type"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	Syncable     bool             `json:"syncable"`
	Claims       []byte           `json:"claims"`
}

type SyncStatus string

type TempEntryVersion struct {
	ID          uuid.UUID  `json:"id"`
	EntryID     uuid.UUID  `json:"entry_id"`
	Name        string     `json:"name"`
	Version     string     `json:"version"`
	Title       *string    `json:"title"`
	Description *string    `json:"description"`
	CreatedAt   *time.Time `json:"created_at"`
	UpdatedAt   *time.Time `json:"updated_at"`
}

type TempMcpServer struct {
	VersionID           uuid.UUID `json:"version_id"`
	Website             *string   `json:"website"`
	UpstreamMeta        []byte    `json:"upstream_meta"`
	ServerMeta          []byte    `json:"server_meta"`
	RepositoryUrl       *string   `json:"repository_url"`
	RepositoryID        *string   `json:"repository_id"`
	RepositorySubfolder *string   `json:"repository_subfolder"`
	RepositoryType      *string   `json:"repository_type"`
}

type TempMcpServerIcon struct {
	ServerID  uuid.UUID `json:"server_id"`
	SourceUri string    `json:"source_uri"`
	MimeType  string    `json:"mime_type"`
	Theme     string    `json:"theme"`
}

type TempMcpServerPackage struct {
	ServerID         uuid.UUID `json:"server_id"`
	RegistryType     string    `json:"registry_type"`
	PkgRegistryUrl   string    `json:"pkg_registry_url"`
	PkgIdentifier    string    `json:"pkg_identifier"`
	PkgVersion       string    `json:"pkg_version"`
	RuntimeHint      *string   `json:"runtime_hint"`
	RuntimeArguments []string  `json:"runtime_arguments"`
	PackageArguments []string  `json:"package_arguments"`
	EnvVars          []string  `json:"env_vars"`
	Sha256Hash       *string   `json:"sha256_hash"`
	Transport        string    `json:"transport"`
	TransportUrl     *string   `json:"transport_url"`
	TransportHeaders []string  `json:"transport_headers"`
}

type TempMcpServerRemote struct {
	ServerID         uuid.UUID `json:"server_id"`
	Transport        string    `json:"transport"`
	TransportUrl     string    `json:"transport_url"`
	TransportHeaders []string  `json:"transport_headers"`
}

type TempRegistryEntry struct {
	ID        uuid.UUID  `json:"id"`
	SourceID  uuid.UUID  `json:"source_id"`
	EntryType EntryType  `json:"entry_type"`
	Name      string     `json:"name"`
	Claims    []byte     `json:"claims"`
	CreatedAt *time.Time `json:"created_at"`
	UpdatedAt *time.Time `json:"updated_at"`
}

type UnlinkRegistrySourceParams struct {
	RegistryID uuid.UUID `json:"registry_id"`
	SourceID   uuid.UUID `json:"source_id"`
}

type UpdateSourceParams struct {
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	Syncable     bool             `json:"syncable"`
	Claims       []byte           `json:"claims"`
	UpdatedAt    *time.Time       `json:"updated_at"`
	Name         string           `json:"name"`
}

type UpdateSourceSyncParams struct {
	SyncStatus SyncStatus `json:"sync_status"`
	ErrorMsg   *string    `json:"error_msg"`
	EndedAt    *time.Time `json:"ended_at"`
	ID         uuid.UUID  `json:"id"`
}

type UpdateSourceSyncStatusByNameParams struct {
	SyncStatus SyncStatus `json:"sync_status"`
	StartedAt  *time.Time `json:"started_at"`
	Name       string     `json:"name"`
}

type UpsertEntryVersionsFromTempRow struct {
	ID      uuid.UUID `json:"id"`
	EntryID uuid.UUID `json:"entry_id"`
	Version string    `json:"version"`
}

type UpsertLatestServerVersionParams struct {
	SourceID  uuid.UUID `json:"source_id"`
	Name      string    `json:"name"`
	Version   string    `json:"version"`
	VersionID uuid.UUID `json:"version_id"`
}

type UpsertLatestSkillVersionParams struct {
	SourceID  uuid.UUID `json:"source_id"`
	Name      string    `json:"name"`
	Version   string    `json:"version"`
	VersionID uuid.UUID `json:"version_id"`
}

type UpsertRegistryEntriesFromTempRow struct {
	ID        uuid.UUID `json:"id"`
	SourceID  uuid.UUID `json:"source_id"`
	EntryType EntryType `json:"entry_type"`
	Name      string    `json:"name"`
}

type UpsertRegistryParams struct {
	Name         string       `json:"name"`
	Claims       []byte       `json:"claims"`
	CreationType CreationType `json:"creation_type"`
	CreatedAt    *time.Time   `json:"created_at"`
	UpdatedAt    *time.Time   `json:"updated_at"`
}

type UpsertServerVersionForSyncParams struct {
	VersionID           uuid.UUID `json:"version_id"`
	Website             *string   `json:"website"`
	UpstreamMeta        []byte    `json:"upstream_meta"`
	ServerMeta          []byte    `json:"server_meta"`
	RepositoryUrl       *string   `json:"repository_url"`
	RepositoryID        *string   `json:"repository_id"`
	RepositorySubfolder *string   `json:"repository_subfolder"`
	RepositoryType      *string   `json:"repository_type"`
}

type UpsertSkillVersionForSyncParams struct {
	VersionID     uuid.UUID       `json:"version_id"`
	Namespace     string          `json:"namespace"`
	Status        NullSkillStatus `json:"status"`
	License       *string         `json:"license"`
	Compatibility *string         `json:"compatibility"`
	AllowedTools  []string        `json:"allowed_tools"`
	Repository    []byte          `json:"repository"`
	Icons         []byte          `json:"icons"`
	Metadata      []byte          `json:"metadata"`
	ExtensionMeta []byte          `json:"extension_meta"`
}

type UpsertSourceParams struct {
	Name         string           `json:"name"`
	CreationType CreationType     `json:"creation_type"`
	SourceType   string           `json:"source_type"`
	Format       *string          `json:"format"`
	SourceConfig []byte           `json:"source_config"`
	FilterConfig []byte           `json:"filter_config"`
	SyncSchedule pgtypes.Interval `json:"sync_schedule"`
	Syncable     bool             `json:"syncable"`
	Claims       []byte           `json:"claims"`
	CreatedAt    *time.Time       `json:"created_at"`
	UpdatedAt    *time.Time       `json:"updated_at"`
}

type UpsertSourceSyncByNameParams struct {
	Name                  string     `json:"name"`
	SyncStatus            SyncStatus `json:"sync_status"`
	ErrorMsg              *string    `json:"error_msg"`
	StartedAt             *time.Time `json:"started_at"`
	EndedAt               *time.Time `json:"ended_at"`
	AttemptCount          int64      `json:"attempt_count"`
	LastSyncHash          *string    `json:"last_sync_hash"`
	LastAppliedFilterHash *string    `json:"last_applied_filter_hash"`
	ServerCount           int64      `json:"server_count"`
	SkillCount            int64      `json:"skill_count"`
}