MCP Toolbox for Databases

// Copyright 2025 Google LLC // // Licensed under the Apache License, Version 2.0 (the "License"); // you may not use this file except in compliance with the License. // You may obtain a copy of the License at // // http://www.apache.org/licenses/LICENSE-2.0 // // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. // See the License for the specific language governing permissions and // limitations under the License. package cloudsqladmin import ( "context" "fmt" "net/http" "github.com/goccy/go-yaml" "github.com/googleapis/genai-toolbox/internal/sources" "github.com/googleapis/genai-toolbox/internal/util" "go.opentelemetry.io/otel/trace" "golang.org/x/oauth2" "golang.org/x/oauth2/google" "google.golang.org/api/option" sqladmin "google.golang.org/api/sqladmin/v1" ) const SourceKind string = "cloud-sql-admin" // validate interface var _ sources.SourceConfig = Config{} func init() { if !sources.Register(SourceKind, newConfig) { panic(fmt.Sprintf("source kind %q already registered", SourceKind)) } } func newConfig(ctx context.Context, name string, decoder *yaml.Decoder) (sources.SourceConfig, error) { actual := Config{Name: name} if err := decoder.DecodeContext(ctx, &actual); err != nil { return nil, err } return actual, nil } type Config struct { Name string `yaml:"name" validate:"required"` Kind string `yaml:"kind" validate:"required"` DefaultProject string `yaml:"defaultProject"` UseClientOAuth bool `yaml:"useClientOAuth"` } func (r Config) SourceConfigKind() string { return SourceKind } // Initialize initializes a CloudSQL Admin Source instance. func (r Config) Initialize(ctx context.Context, tracer trace.Tracer) (sources.Source, error) { ua, err := util.UserAgentFromContext(ctx) if err != nil { return nil, fmt.Errorf("error in User Agent retrieval: %s", err) } var client *http.Client if r.UseClientOAuth { client = &http.Client{ Transport: util.NewUserAgentRoundTripper(ua, http.DefaultTransport), } } else { // Use Application Default Credentials creds, err := google.FindDefaultCredentials(ctx, sqladmin.SqlserviceAdminScope) if err != nil { return nil, fmt.Errorf("failed to find default credentials: %w", err) } baseClient := oauth2.NewClient(ctx, creds.TokenSource) baseClient.Transport = util.NewUserAgentRoundTripper(ua, baseClient.Transport) client = baseClient } service, err := sqladmin.NewService(ctx, option.WithHTTPClient(client)) if err != nil { return nil, fmt.Errorf("error creating new sqladmin service: %w", err) } s := &Source{ Config: r, BaseURL: "https://sqladmin.googleapis.com", Service: service, } return s, nil } var _ sources.Source = &Source{} type Source struct { Config BaseURL string Service *sqladmin.Service } func (s *Source) SourceKind() string { return SourceKind } func (s *Source) ToConfig() sources.SourceConfig { return s.Config } func (s *Source) GetDefaultProject() string { return s.DefaultProject } func (s *Source) GetService(ctx context.Context, accessToken string) (*sqladmin.Service, error) { if s.UseClientOAuth { token := &oauth2.Token{AccessToken: accessToken} client := oauth2.NewClient(ctx, oauth2.StaticTokenSource(token)) service, err := sqladmin.NewService(ctx, option.WithHTTPClient(client)) if err != nil { return nil, fmt.Errorf("error creating new sqladmin service: %w", err) } return service, nil } return s.Service, nil } func (s *Source) UseClientAuthorization() bool { return s.UseClientOAuth }