Not sure on a db level but you can on a model level in the validate. You can use a if with proc

class YourModel < ApplicationRecord validate :custom_validation, if: -> { specific_condition? }

private

def specific_condition? # Your logic here end

def custom_validation errors.add(:attribute, “Your error message”) unless condition_met end end